Second form to navigate to record displayed in first form

[Isabella_Adeline]

I have two forms: Country Information & Documentation Information which are
based on like name tables which have a one (country) to many (documentation
Information) relationship.

I have created a command button on Country Information form to open
Documentation Information form. When it opens, it navigates to the first
record in the database and I want it to navigate to the record I was on when
I pushed the button.

Ie. I'm looking at the Country Information for Mexico and when I push the
button, I want to look at the documentation requirements for Mexico.

I originally based the Documentation Requirements form on a query and tried
using the following to restrict the query:

[Forms]![Country Information]![Country Name]

With no luck.

Any help would be greatly appreciated.

 

[Daryl S]

Candie -

If you are adding a filter in the new form, then you need to give the field
name also, like this (assuming the record source for the second form has a
field called [Country Name]:

[Country Name] = [Forms]![Country Information]![Country Name]