Continuous synchronization of two forms

[Saintor]

This should be more simple!

Can anybody post an example that I could adapt. I have tried many ways (me.requery, me.refresh, name it) but it just doesn't work.

I don't want to open the form at each time.

Thank in advance.

 

[ghubbell]

Me.EnterTheNameOfYourSubFormAsItIsSeenByTheMainForm.Requery
Click once on the subform in design view thru the main form and check what its name within the main really is. Hope this helps. Gord
ghubbell@total.net

 

[7ony]

Assuming you have 2 completely independent forms, you can reference the forms by their names Forms!FirstForm and Forms!SecondForm. This can be done inside the other form or inside independent code. No need to use 'Me'. Me is used for the current item only. For example Me.Name is the name of the current Form. If the Query in the Second Form references a field in the first form, then a .Requery will work, but so fill changing the .Filter

Heres some code that may help...
DoCmd.OpenForm "FirstForm"
DoCmd.OpenForm "SecondForm"
Forms!SecondForm.Filter = "[DueDate] = #02/19/2001#"
Forms!SecondForm.FilterOn = True

G'Luck
7ony