Strange Invalid Argument Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I've got this code running on the OnCurrentEvent :
rst.FindFirst "[fldLot]='" & Left(fldLot, 7) & "-" & nbrtemp & "'"
It runs fine, I can move from record to record however if I open the "Find"
windows and do a search it gives me "invalid argument" error message.
any ideas?

TIA,
Gix
 
I'm going to need a better explanation. What you have is doing a search on a
recordset defined in the variable "rst" every time you move from one record
to the next. It will even fire when you go to a new record. Opening the Find
window will do a search on the form or in code, depending on whether you're
in the Access window or VBA window when you open Find. By your description,
it appears that you're in the Access window. What are you typing in the Find
box?
 
Back
Top