multiple field primary key searches

[cochise]

Any help on what the code would be behind a cmd button on a form whose purpose is to search for a record in a table with a primary key consisting of the following three fields:

EmpNum, Date, InvNum

It needs to search on all 3 fields.

Thanks for the help.

 

[braindead2]

IF I understand what you are trying to do something like below should work

select * from table where key = EmpNum & Date & InvNum
or
select * from table where EmpNum & Date & InvNum = key

 

[cochise]

Actually the form is based on a query. Are you saying I have to change the record source in my code?