Synchronizing forms (1 Viewer)

[MICHELE]

I am trying to open a form based on what is entered in another form.
There are 3 forms involved: main form (draftingschedule), sub form(subdrafting), another subform(subdrafting-id).
I want subdrafting-id to open based on what is chosen in subdrafting.
Drafting Schedule and subdrafting are linked by LSC. Subdrafting and subdrafting-id are linked by an ID field.
I can make it work when subdrafting is opened up on its own without the main form. But when I open it up using the main form it doesn't work. I am using the OnCurrent event .

 

[David R]

Look into using OpenArgs, or the Access help file on 'synchronize records between two forms'.

HTH,
David R

 

[MICHELE]

I read about in in help and found out how to do it in a book. I can make it work until I try to use it on a subform. For some reason the on current doesn't work the same for the subform.

 

[Cosmos75]

Hope this helps!

ACC2000: Using Code to Dynamically Synchronize Two Forms (Q210060)
http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q210060


ACC2000: Subform Not Synchronized with Main Form in Microsoft Access Project (Q236368)
http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q236368

 

[cinders]

Same Problem

Michelle,

Did you sort this out and if so, culd you pass along what you did. I am having the same problem.

Thanks

Cindy

I read about in in help and found out how to do it in a book. I can make it work until I try to use it on a subform. For some reason the on current doesn't work the same for the subform.