I am in the process of doing a database and have created several forms and subforms. I want to go into each form using command buttons but the linked is not updating the second form. It works okay as a sub form but not on the command button.

Any assistance would be grateful. Can anyone help.

Thanks
Jackie Aitken

Are you trying to open Form2 from Form1 and have Form2 open to the same record that Form1 is on when you click the Command button? If so, then create you Command button using the Wizard and select Form Operations. One of the options you will be given when using the Wizard is to open the form at a specific record. Tick that radio button then follow the rest of the instructions.

HTH,
Jack