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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid argument problem 2
Access Switchboard error message 1
"Invalid Argument" error 4
Invalid argument? 7
Access ACCESS DLOOKUP INVALID USE OF NULL 0
Invalid Argument 5
Invalid Argument when running a Make Table Query 3
invalid argument 3

Back
Top