search form

  • Thread starter Thread starter y
  • Start date Start date
Y

y

Hello, I am trying to create a search form where someone
can enter and ID, name, or address and hit find to find a
particular person. There is an entry part as well as a
subform below the entry part. That subform is based on a
query that contains all peoples information. How can I
create the form so that the data entry part is not used to
update the table but only to look up that information in
the subform below it?

Thanks!!!
 
Use the combobox wizard to create comboboxes for the fields
that you want to search for in the form header. Choose the
wizard option to 'Find records on my form based on the
selection'. Now in your form properties turn AllowEdits to
No and they won't be able to mess with the data.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top