View Single Post
  #2  
Old April 26th, 2010, 02:18 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default How to find a record using more than one field?

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.