Search Form

[Pat]

I'm trying to design a search form from a table where I
can search for records from the table from each field in
the form and add records not found.Can someone offer me a
step by step on this or at least the key properties needed
on the form and table?

 

[Albert D. Kallal]

Have you tried used a query by form? This feature is built in.

while looking at a form, go records->filter->filter by form.

I don't like using the above feature because I never open a form to a table
without using a where clause and limiting the records. However, you do owe
yourself to spend some time paving with the above.

I mean, for a customer invoice, usually name, company, invoice number is
acceptable for searching. So, if the above query by form is not what you are
looking for, then you can bite the bullet, and start coding your own
customer forms, but they are a bit of work.

Here is some screen shots of a search form I made...it might give you some
ideas:

http://www.attcanada.net/~kallal.msn/Search/index.html