Form Search *urgent*

[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.

 

[Art]

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

 

[Guest]

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!

 

[Adrian Jansen]

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