Problem is on one table. Form is based on a single table query (select *). For presentation purposes, some of the memo fields are in other forms. Forma are linked by ID_no. Command button to look at memo form from main form. If record is edited in main form and then memo entry is edited in linked form (still one record) access says record has been changed by another user and gives option to save/copy/abandon change. [sig][/sig]
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking problem
- Thread starter mfd777
- Start date
mfd777,
Is the memo field a bound field on the second form? If it is this is causing the problem. The second form should probably be completely unbound and Form_Open and Form_Close code should be written to populate the memo field and save any updated results back to the recordset on the parent form. [sig][/sig]
Is the memo field a bound field on the second form? If it is this is causing the problem. The second form should probably be completely unbound and Form_Open and Form_Close code should be written to populate the memo field and save any updated results back to the recordset on the parent form. [sig][/sig]
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
