Find a record by criteria

G

Guest

I've created a "start up" form where the end user can navigate to do data
entry, update tables, pull reports or do a record search based on specific
criteria - all by using the associated command button. However, I am unable
to get the record search button(s) to work. The goal is to have the user be
able to find a record based on Case number, agent name or date created - each
with its own button. For example, by pressing the CaseNumber button, the
user is prompted to enter the case number and if it is one of the records the
record form will appear with the case information. I have tried using the
command button/wizard for FINDRECORD but an error message appears saying that
the record could not be found now. If there is no record a message is to
appear advising of such.

thanks!
 
A

Al Camp

Gail,
On my web site, I have a sample 97 or 2003 file called Combo Quick Find.
It demonstartes how to locate a specific record by entering or selecting a value from a
unbound Combobox... which lists only legitimate values.
Also, the NotInList for the combo will prevent trying to locate non-legitimate values.
 
G

Guest

Thanks Al for the link. Unfortunately I am unable to view the examples.. have
Access 2000. Can you offer any other suggestion?

regards,
Gail
 
A

Al Camp

Gail,
You should be able to download the 97 version and convert it into 2000.
It's a bit time consuming to explain all the steps in creating the combo, populating
it, and then using the selection to find a record... and probably would be much more
confusing than actually seeeing how it works.
Basically though...
Create an unbound combo on your form.
Populate it with legitimate values from the recordset you are searching in.
(should be a unique value like PartNo, CustID, PONumber, etc... so ther is
only one legitimate answer to the Find)
Use the AfterUpdate event of the combo to use the value selected to Find the
record you want.
 
G

Guest

Al,

When I open the 97 version I receive the following message "The current user
does not have permission to convert or enable the database." Thank you for
your assistance.. will continue to search for the answer.

regards,
Gail
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
checking for existing record 3
if form open criteria is blank, I do not want a new record to open 1
Find Record in Subform 1
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1
DMax on existing record to increment serialized # fails 1
Going to first record 0
Back to first record, then forward 2

Top