Recordset Update (1 Viewer)

[muratas2]

Hi,

I have a form based on table tblX. I need to update some date on this table openning a recordset and dynamically update the data on the form. Unfortunately I can't change any record on the table since the form is open, recordset.update doesn't work. Do I need to close the form and open again each time? Is there a better way?

Thanks in advance

Murat

 

[TomK]

Check your record lock option under Tools | Options | Advanced. You may have All Records selected. If so, try Edited Record. However, if your form is 'dirty' then that record will be locked. If that's the case, try saving the record first.