Hi, I have been looking through the internet for some time now trying to find out how to search a dataset for records based on a user input textbox at runtime. Basically a query which updates the dataset automatically with the results on a button click with a given parameter being searchtxt.text.

Anyone got any suggestions for this, at least which direction to point me in? Any help will be most appreciated. Thanks

You can use the Find method of the record set

RS.Find("FName='Bob'", , adSearchForward)

Find will allow wild card searches using like also

Hope you get what you wanted

Cheers
Shasur



http://www.vbadud.blogspot.com

Hi, thanks for the quick reply, Im pretty new to VB in general but entirely new in this subject. I understand the syntax of the code you listed as an example but Im not sure how to define a recordset or at least how to implement the code properly, Thanks

The VB help system has a lot of info on how to create and populate recordsets.
It is not hard, but there's a lot of code that you can already find at your fingertips...

Recordsets are objects, so you must delare them (Dim MyRecSet as . . .), intstatiate them (Set MyRecSet = New . . .) and open them (MyRecSet.Open("SELECT . . . ", . . . ).

The environment matters. From within Access the process is different than, say, within Word’s VBA, or within the VB Integrated Development Environment.