I have a command button on a form that uses the data entered into an unbound textbox as the criteria for a seek on an applicable index field of a recordset.
I have the seek process of finding a record working in other modules - but in this instance I get the error message 'Operation is not supported for this type of operation' ???
Dim db As Database
Dim rstVehs As DAO.Recordset
Dim strRego As String
Set db = CurrentDb()
Set rstVehs = db.OpenRecordset("tblVehicles")
strRego = [Forms]![frmOpLookup]![txtRegoNo]
rstVehs.Seek "=", strRego
It fails on .Seek command line - What am I doing wrong ?
Any help appreciated.