Urgent - Searching ADO Recordssets

[HanneSThEGreaT]

How do I create a search ado record facility on my forms?
Can anyone help, Please...

Thanx

F. T. W.

[Robert Moy]

Hello:

If I understand what you mean, you can use this program which will allow an user can input thier column and data to be searched.
[\vbcode]
Adodc1.RecordSource = "Select " & Text3.Text & _
" from " & Text4.Text & _
" WHERE " & Text5.Text & "=" & Text6.Text
Adodc1.Refresh
[/vbcode]

Good Luck

[HanneSThEGreaT]

Hi Robert. I haven't made use of the adodc control, I've selected the Ado Code Option on the DataForm Wizard, how can I do it without the adodc control?

Thanx
Hannes

F. T. W.

[Iouri]

sSQL = "select * from Table where Field = YourCriteria"

rs.Open sSQL, adOpenDynamic, adLockOptimistic

now recordset contains your search criteria and you can do whatever you want with it.

Iouri Boutchkine
[email protected]