Records not matching

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

Guest

I have two tables that are linked by a customer code. I have two forms one
for each table. On the first form Ihave a button that links me to the second.

The problem that I have is that I need the second form to open up on the
corresoponding record. aat the moment if i go to customer 3 click on the
button that links me to the second form I need to scroll through to customer
3 record.

Is there any way that I can get it set up that If I have customer 3 record
open when I click on the second form that it will open showing customer 3
info.
 
You can use the WhereCondition parameter of docmd.openform and use the
linking field as the criteria:

docmd.OpenForm "frmTest",,,"Custid=" & me.custid
 
Back
Top