I'm using access to edit several tables within one main table.
I've got the main data and about 3 sub-forms - the problem:
everytime I make an update - i do a docmd.runsql to edit a 'modify date' field wich contains the last date/time (not stamp) of the modification.
No lets say im editing an article in a sub-form and after that in the main form - at the first character i type i get 'data was changed from another user'... or something like that - could this be a problem of the docmd.runsql?
I've tryed with requeries on this field - if possible i don't want to requery the complete record - that would take much time.