If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Second form to navigate to record displayed in first form
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. -- Candie |
#2
|
|||
|
|||
Second form to navigate to record displayed in first form
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] -- Daryl S "Isabella_Adeline" wrote: 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. -- Candie |
Thread Tools | |
Display Modes | |
|
|