It may only be a matter of semantics, but when you have a field named "ID",
the implication is that this is a unique row identifier. As such, you would
NOT need to do a find by both ID and "date fields", since the ID would
already be unique.

.... but maybe this isn't how you are using the field name...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Messen" wrote in message
...
I have created a table with several fields such as ID, name, date, etc. I
also created a switchboard with a find command to locate a record in forms
view . However the find command only searches under one field. Can I
create
a find command that matches 2 fields? I want my find command to find a
record in form view that matches both the ID and date fields.