Sorry for the lack of response. I was out of town for a week.

You cannot use your method to search two fields simultaneously on two
different values. This will require VBA and a form to input the two values
you want to search for.

Do you want to limit the results to display to just the records that match
your criteria (filter the records)?


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Messen wrote:
I created a find record macro with three commands. (Real basic stuff here)
I used three commands. "OpenForm", then "GoToControl", then "RunCommand". I
then used a command button on the switchboard form to run the macro. The
problem here is, I have no VBA training. If VBA is required I would need to
know the whole code and how to link it to the comand button I quess.

I may be asking for more than my skill level is able to perform.


"John Spencer" wrote:


Messen wrote:
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.
.