synchronization of subform to main form

[Charles Phillips]

Hello,
I am using MS-Access 97
I have a main form called DM.
I created another form called VPN
I want the VPN form to be a subform in synchronization with the main form
DM.
Can ANYONE provide me with some reference examples???


Charles L. Phillips

 

[Albert D. Kallal]

If you setup the relationships between the tables in tools->relationships,
then ms-access can sync them for you.

In fact, you don't even have to setup the relationships window..but you
should.

If you create the two forms, then simply open up the main form (dm) in
design mode. You can now drag and drop in the child form, and they will sync
for you. If they don't sync, then check out the properties sheet for the
sub-form..and set the link master/child fields.

I don't have some good sub-form example downloads......but I do have some
notes on how to use sub-forms..and why they are so great here

http://www.attcanada.net/~kallal.msn/Articles/fog0000000005.html