How do I create a search ado record facility on my forms?
Can anyone help, Please...
Thanx
F. T. W.
Printable View
How do I create a search ado record facility on my forms?
Can anyone help, Please...
Thanx
F. T. W.
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
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.
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]