Opening the same record in another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'.
 
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...
 
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
 
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...
 
Back
Top