Record-locking with an append query 1

[TracySHC]

I'm new to the record-locking problems in Access, so please let me know if I'm posting this question in the correct forum. I have a form which updates a table. An append query uses this table to update another table. If I have a value entered on the form (so the record is locked for editing), the underlying table is updated. However, the append query will not pull the locked record. How should I proceed so that the append query will pull all records in the table?
Thank you in advance for all help and advice,
TracySHC

 

[lameid]

Quit editing the record?

Perhaps save the record first?

In VBA..

docmd.runcommand acCMDSaveRecord