Form Search *urgent*

  • Thread starter Thread starter Cimmy
  • Start date Start date
C

Cimmy

I'm pretty new to Access, and am using 2000. I have a
form that will update a specific field in my database.

I have 500 records and want to be able to navigate to a
specific record based on a key value rather than having to
scroll through ALL of my records. How can I do this??

Ideally, I'd like to select my key value and have all of
the fields populate based on that criteria.

Thank you in advance.
 
Hi Cimmy,
A combo box on your form seems like the way to
go. You could select a key value and the form would update
depending upon that value. Use the combo box wizard on the
toolbar and follow it along.

Hope This Helps
 
Thanks for you quick response! I can get a list of
everything in my key field, I guess my problem comes with
updating subsequent fields based on that field.

Like if I select "Customer", I want the address, phone,
email addresses to be based on that field I picked. I
can't figure out how to do that.
Thanks again!
 
You realise that Access has some search/filter facility already built in ?
Select the field you want to search in, right-click, select Filter on the
popup menu and enter the search term in the search dialog box. This will
find the entry you want.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top