When using the FindFirst method I seem to be able to locate only records which are defined as strings using a variable in the search pattern.
When I am searching for integer values I cannot find the correct syntax to pass the variable name at best I get a response of Type mismmatch when I pass it as a string.
If I replace the variable with a constant (eg 1 or 2) then no problems — the record is found.
All referances I have seen only refer to searching for strings
You can just say:
RecordSet.FindFirst “integerfield = ” & val(TextBox.Text)This will do a find of ‘integerfield = 3’, for example.