Compound primary key lookup

[bojbrown]

I have a table with a primary key made up of 2 fields: A user's ID and a date.

I know how to find a specific record with only one field, but there doesn't seem to be any command in Access to go to a specific record with a compound primary key, especially when you are trying to display a specific record in a form. If there is, I certainly have missed it or do not understand how the command works.

Hopefully someone can shed some light on this for me.

Thank you.

 

[namliam]

You can do a compount search using And in the where statement of the dlookup....

Hope that helps you along...

Greetz

 

[bojbrown]

Thank you for the reply, but I know how to use dlookup and can use this command to determine if the record exists. But the problem, especially in a form, is making a specific record the current and active record in a form based on a user's input. All commands to do this seem to revolve around a primary key with only 1 field, not one with 2 or more.

If there is such a command in Access forms, please tell me. This has been real perplexing.

Thanks.