Same record different forms

[Leslie Coover]

Access 2002

I have 2 forms based on one table. How can I switch back and forth between
the forms and stay in the current record. Do I need to do more than make
sure the primary key is displayed on both forms?

Thanks,

Les Coover

 

[Allen Browne]

See:
Using Code to Dynamically Synchronize Two Forms
at:
http://support.microsoft.com/kb/210060/en-us

You are likely to have concurrency problems if you permit editing in both
forms, or if there are any memo fields involved.

 

[Leslie Coover]

Thank you for information, I found out the Access Wizard that can be used
with command button insertion has an option that will link forms together
(current record stays in view).