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

S

sullshell

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?
 
J

jahoobob via AccessMonster.com

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.
 
Top