Search

[DirtDawg]

quick question, I would like to search the cureent record set in Access to display what I am looking for? without having a pop up window.

Thanks in advance

 

[VBslammer]

You mean like an address bar using a textbox and a search button?

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[PHV]

You may consider the 3rd option of the combo wizard.

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

 

[DirtDawg]

Actually I wanted a textbox with a search button on the form itself. So that i could serach the recordset in use at the time. then be able to update the record that was found if it was in correct.

Regards,

 

[PHV]

Take a look at the RecordsetClone, FindFirst, NoMatch and Bookmark methods/properties of the DAO.Recordset/Form objects.

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