Sometimes can't save with Wizard's Save button

Tech-Archive recommends: Fix windows errors by optimizing your registry

I need to replace the DoMenuItem command below:

DoCmd.DoMenuItem _
acFormBar, _
acRecordsMenu, _
acSaveRecord, , _
acMenuVer70

With something that will update the record with all the fields that have
changed. Maybe a loop or somthing that will cycle through all the controls
on the form that have a control source.

The reason is the DoCmd.DoMenuItem method is causing all Access (2003)
clients to get locked out of certain blocks of records and I can't seem to
find any answer why.

The reason I want something that will loop through the controls is because I
am using the DoCmd routine as a part of a function that all my data entry
forms call. For example I have a form that has ReturnNumber, Customer,
Priority, etc and another that has TuningNumber, Customer, Status, Rev, etc.
so I can't build hard coded SQL queries for each.



.

Quantcast