FInd Seek

[giggs11]

I know that for Data control you can use the Index and Seek function to search for records, but what do i use for the Ado control? Also, how do i set conditons? eg. User cannot go on to the next field without entering something in the previous field.


Simon

 

[Imhoteb]

Hi,
with an adocontrol you can use the Find method
Say you have following controls on you form
ADO1 'AdoControl
Text1 'Textbox where the data is you have to look up

With ADO1.Recordset
.MoveFirst
.Find "myField='" & Text1 &"'"
If .EOF Then
MsgBox txtPostkode & " not Found."
Else
'Put your code here
End If
End With

Hope this helps
Good luck