SEARCH ROUTINE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tarlac - 09 Mar 2006 14:31 GMT

I have a form that allows add/edit /view ENTRIES. The record source of my
form is the master_table (not a query) that contains all the ENTRIES. I used
the record navigation functions of ACCESS (prev record, next rec, add rec,
find a record and so on..)
I am new to ACCESS and no experience in VB coding. Now that my master_table
is getting bigger, I understand it will be faster if I have a SEARCH routine
that queries only a record or a set of records instead of fetching all
records of the master_table by using the FIND function of access.
Is there a template/sample code/approach for a SEARCH routine that I can
start on , that will allow my users to search for the LAST NAME of a member
and displays the member info on the form. This way it will only fetch that
record instead of retrieving all the records of the master_table which my
form is currently doing.
Thanks in advance for your help.

Reply to this Message

Deborah Jean - 10 Mar 2006 12:09 GMT

as long as Last Name is a field in a table you can do a query. Or a filter
by selection this is on the table's toolbar. Click it and then in last name
to search for all that begin with s type in S*
Note that you can't save a filter as easily as a query. if it is one to be
used over and over then a query would better suit you.

> I have a form that allows add/edit /view ENTRIES. The record source of my
> form is the master_table (not a query) that contains all the ENTRIES. I used
[quoted text clipped - 10 lines]
> form is currently doing.
> Thanks in advance for your help.

Reply to this Message