UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Requery, Access 2016    
 
   
mike60smart
post Jun 2 2020, 05:33 AM
Post#1


UtterAccess VIP
Posts: 14,072
Joined: 6-June 05
From: Dunbar,Scotland


Hi Everyone

I have a Main Formnamed "SOHeader" and a linked Subform named "SODtlsfrm"

I also have a subform displaying data from a Temp Table called "frmCumulativeTotalsSubform" This Form is not linked to any of the other 2 Forms.

On the subform "SODtlsfrm" I am running an Insert On Click Event which inserts all relevant data into the required tables.

What I cannot seem to do is Requery the "frmCumulativeTotalsSubform"

I have tried all combinations with no success.

Any help appreciated.

--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
missinglinq
post Jun 2 2020, 06:51 AM
Post#2



Posts: 4,708
Joined: 11-November 02



What, exactly, does 'all combinations' means? We need to see what you've tried.

From where are you trying to do this...from the subform...from the main Form?

"frmCumulativeTotalsSubform" sounds as if it contains calculated Fields...if so you may need to use Me.Recalc rather than requerying it.

Linq ;0)>

--------------------
BTW...The Monkey is laughing at me...not at any other poster!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page
 
mike60smart
post Jun 2 2020, 07:11 AM
Post#3


UtterAccess VIP
Posts: 14,072
Joined: 6-June 05
From: Dunbar,Scotland


Hi Ling

I have tried:-

[Forms]![SOHeader].[frmCumulativeTotalsSubform].[Form].Requery
Me!frmCumulativeTotalsSubform.Requery

The On click Event is on the Subform "SOdtlsfrm"




--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
mike60smart
post Jun 2 2020, 07:59 AM
Post#4


UtterAccess VIP
Posts: 14,072
Joined: 6-June 05
From: Dunbar,Scotland


Hi Ling

Forget this as I was trying to requery the wrong Form

My mistake and sorry for trouble


--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
missinglinq
post Jun 2 2020, 02:09 PM
Post#5



Posts: 4,708
Joined: 11-November 02



No problem...glad you got it working!

Linq ;0)>

--------------------
BTW...The Monkey is laughing at me...not at any other poster!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    3rd August 2020 - 03:55 AM