Open Form w/Criteria

[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

 

[Rick Brandt]

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.

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