Form jump to a record where another form is

[ppataki]

Dear All,

I have 2 forms, both are bound to the same table, but with different fields
How can I achieve that if I click on the second form (OnActivate I assume) it displays the record that is displayed in the first form?

Many thanks in advance

 

[Mr. B]

Take a look at the DoCmd.OpenForm method and use the "Where" parameter of this method, passing the record ID for the currently displayed record on the first form.

The Where parameter is just structured just like the criteria for a query. Check the Help file of Access for details.

 

[ppataki]

Many thanks, it works perfectly!!

 

[Mr. B]

Your quite welcom. Glad to help.

Good luck with your project.