Opening the same record in another form

A

aj20

Hello, I have a table call 'Allrecords' and it has a field called ContactID
set to autonumber. I have a form called 'Alphabetical View of Contacts'. I
have another form called 'Customer Details'. I want to double click on the
name field in the first form (Alphabeticall ... ) and be able to open the
same record in the second form (Customer Details). how can I achieve this.
thanks. All the forms above use the table 'Allrecords'.
 
A

AlCamp

aj20 said:
Hello, I have a table call 'Allrecords' and it has a field called
ContactID
set to autonumber. I have a form called 'Alphabetical View of Contacts'. I
have another form called 'Customer Details'. I want to double click on the
name field in the first form (Alphabeticall ... ) and be able to open the
same record in the second form (Customer Details). how can I achieve this.
thanks. All the forms above use the table 'Allrecords'.
Click to expand...
 
A

AlCamp

AJ,
Use the WhereCondition argument of the OpenForm method to open the second
form to the unique record you clicked on the first form.

example where condition...
"ContactID = Forms!frmYourFirstFormName!ContactID"

hth
Al Camp
 
A

aj20

Thanks, that was easy.

AJ

AlCamp said:
AJ,
Use the WhereCondition argument of the OpenForm method to open the second
form to the unique record you clicked on the first form.

example where condition...
"ContactID = Forms!frmYourFirstFormName!ContactID"

hth
Al Camp
Click to expand...
 
Top