Searching in a table or form

[wfairbanks]

I have an access form that populates a table. I would like to be able to search that table for a specific record. I am not sure how I need to do this.

 

[EBGreen]

You can use SQL to select the record(s).

 

[luceze]

What version of Access are you using?

Eric

 

[wfairbanks]

Access 97!

 

[luceze]

One more question. Do you need to search through the table itself or are you trying to pull up a record in your form that corresponds to your search criteria?

Eric

 

[wfairbanks]

I am trying to pull a record itself to modify it. I have several to update information on and I wanted a quick way to pull each record up one at a time and make the necessary changes.

 

[PHV]

You may take a look at the Filter and FilterOn properties of your form.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884