HELP! Search Forms!!

[Stephen Kempin]

PLEASE HELP!! I was wondering if anyone could help me as I am trying to
create a form to SEARCH a database with. It's a very simple one-table
database, which just holds one table of contacts information (business type,
business name, address, postcode, contact name, contact surname, telephone
code, telephone number, and e-mail).



I want to create a form that I can search the table with. Basically I'd like
to use a similar form to which I use to put contact information in with. I'd
like to choose which fields to specify information in, and then click a
search button and have the database filter the contacts table for entries
with the specified information.



For example, I want to search for contacts with the surname 'James' and with
postcode 'WE4 3ES', I'd like to just fill the Surname and Postcode sections
of the search form in with these details, and then click a search button and
have the results pop up.



I REALLY need quite urgent advice on this! If anyone could advise me how to
achieve this, or has another method of achieving the same search function,
please contact me!! I heard something about using SQL, but am not sure if
this is appropriate or how to use it.



My e-mail is (e-mail address removed) Cheers!! Thanks!!

 

[Rick Brandt]

PLEASE HELP!! I was wondering if anyone could help me as I am trying
to create a form to SEARCH a database with. It's a very simple
one-table database, which just holds one table of contacts
information (business type, business name, address, postcode, contact
name, contact surname, telephone code, telephone number, and e-mail).



I want to create a form that I can search the table with. Basically
I'd like to use a similar form to which I use to put contact
information in with. I'd like to choose which fields to specify
information in, and then click a search button and have the database
filter the contacts table for entries with the specified information.

Have you looked at the built in Filter-by-form feature? Should do exactly what
you want.

 

[Stephen Kempin]

How does this work??

Have you looked at the built in Filter-by-form feature? Should do exactly
what you want.

 

[Rick Brandt]

How does this work??

If you have a form bound to your table there is a button in the Toolbar that
invokes "Filter-by-Form" whenever the form is open.