find record on form2 that matches the record on form1?

[WinDancer]

Everything I have tried so far just changes the ID of the record on form 2...
I just want the matching record
Thanks

 

[Kryst51]

What do you mean by matching record? The same record from the same table? Or a record from another table that is related to the first by that ID?

Also, what are the record sources for your forms?

 

[boblarson]

Basically

DoCmd.OpenForm "FormNameHere", acNormal, , "[FieldToLimitBy]=" & Me!YourFieldOnForm1

If text:

DoCmd.OpenForm "FormNameHere", acNormal, , "[FieldToLimitBy]=" & Chr(34) & Me!YourFieldOnForm1 & Chr(34)

If Date:

DoCmd.OpenForm "FormNameHere", acNormal, , "[FieldToLimitBy]=#" & Me!YourFieldOnForm1 & "#"

 

[WinDancer]

The record from form1 is just a user supplied ID- there is no table just the form.
The record for form2 is from a table that contains the IDs that I need to match.
Just one table and two forms with IDs-
I want the second form to open to the record that matches the ID on the first form

 

[WinDancer]

Thanks, Bob- perfect!