Sychronizing Main Form and Subform

Dave Titan

Registered User.
Local time
Today, 21:33
Joined
Jan 1, 2002
Messages
69
I have a main form that data is entered into, And a subform within it that displays certain fields from the main form (ie Full addresses). The Data entered in the main form correctly places and appears in the sub form. The problem is, when I move onto a new record with the main form, the sub form stays with previous!!
This is not good as it means your reading the wrong address in the subform unless you manualy try to match up Contact ID's which is not practical.

I know no code, and have no experience with it. So please be gentle with the answer!!
Thanks for the help, much appreciated
 
Be sure that you have the Master/Child links for the subform set to ContactID if that is the common field for the form and subform.
 
Both master and child links have been associated with the same contact ID, still same problem.
When ever I click new record in the main form, the sub form stays in the previous record!
 
Yes success, Thank You. I was getting confused when Access asked me either to enter my own common links, or choose all(which is default). Even with child/master links the same in the form, it seems that when creating a new subform, you should select your own fields to link, and then pick Contact ID.

Thanks Again, you just made by DB that bit better!!! now if I can only get the password thing sorted.....

[This message has been edited by Dave Titan (edited 01-01-2002).]
 

Users who are viewing this thread

Back
Top Bottom