Second form to navigate to record displayed in first form
in [Form]
|
From: Isabella_Adeline on 23 Mar 2010 12:22 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
From: Daryl S on 23 Mar 2010 13:06 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
|
Pages: 1 Prev: Subform - problem populating fields Next: Cannot bind a combo box to a memo field |