Find Record

  • Thread starter Janis in Minnesota
  • Start date
J

Janis in Minnesota

Instead of using a Macro to find a record in a lookup, I need to first make
sure the record is not locked. I check this on the before update property
and if it is locked I do not allow the:

DoCmd.FindRecord cboFileNumberLookup.Column(0), acAnywhere, False,
acSearchAll, True, acAll

to execute. This above code does NOT return the Id I need to select the
record with. What is wrong with the syntax?

Any help is greatly appreciated! Thanks!!!

Janis
 

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

Select Text to End of Footnote 9
DoCmd.FindRecord error 3
Find Record 1
FindRecord Problem 7
Find Button 1
Find Record Error 0
if find record 2
Search box in form. 0

Top