Sync two forms....

[dennissanford]

New user to Access.....have Form1 with a subform and a "Command Button" on subform of Form1 set to open Form2. Form2 contains more specific detail of some information contained in Form1. I have studied the information regarding the design of the macro necessary to sync two forms but it does not seem to work. Can anybody help?? Thanks.

[pbaldy]

Does this help?

http://www.baldyweb.com/wherecondition.htm

[dennissanford]

Does this help?

http://www.baldyweb.com/wherecondition.htm

Thanks for your immediate reply. Unfortunately I am not familiar with using VB code, only use Macros.....can you translate for me? Thanks.

[pbaldy]

I don't use macros, but they have a wherecondition argument. You'll have to look in help, as the syntax is a little different.