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
 
Top