Open Form w/Criteria

  • Thread starter Thread starter Eric C
  • Start date Start date
E

Eric C

Hello,

I have a form with a recordset that has 3 primary keys.
How do I go about opening the form from another form and
filtering the data based on the 3 primary keys. If there
was 1 key - it would be simple enough, how is it done
with more than 1.

Thanks,

Eric
 
Eric C said:
Hello,

I have a form with a recordset that has 3 primary keys.
How do I go about opening the form from another form and
filtering the data based on the 3 primary keys. If there
was 1 key - it would be simple enough, how is it done
with more than 1.
Click to expand...

DoCmd.OpenForm "FormName",,,"Field1 = 5 AND Field2 = 'huh' AND Field3 =
#1/1/1998#")
 
Back
Top