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:

Yes, it is possible. There are several methods that should work.

Can you post what method you used to for your find command? Then if you used
VBA code we can suggest a modification to the code.

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

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.
.