How do I stop a form locking table when it opens?

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

Guest

I want to update a table that a subform uses to get its records from using an
update query using code while the form is open. I can't because the Table is
loced by the form. How do I stop the form locking the table so that the
update query can run?
 
Why do you want to update a table, via and update query, that you are
currently updating in your form? If it needs updating from another source,
run the query before opening the form.
 
Back
Top