VBA in form view overriding imported table data

[thoughtgrenade]

Hi everyone,



I'm new to creating DBs, and I just used an append query to add data into the proper table in Access (which worked fine). My problem is when I pick any of the data entries and open them in form view, my VBA from graying out certain fields with AfterUpdate events are causing some comboboxes and checkboxes to not be selected even though they originally were in the table data. When I go back to the table, my data is then updated without the checkboxes and certain fields because the form view changes caused updates.

[ItsMe]

Bound controls are capable of updating data ion the table(s).

[thoughtgrenade]

Yes, I know that anything that updates in form view will update in table view. But how would I go about correcting the code or way that I'm approaching this. For instance all the entries that I've appended have "Suspend" checked as well as a DateEffective. But because my VBA is programmed such that DateEffective is grayed out and disabled until Suspend is checked in the form itself, when I open the table entry in form view, Suspend is unchecked and DateEffective is blank, even though both fields originally existed in table view.

[ItsMe]

When I run UPDATE queries or update records via DAO I usually use the values from the form and update other tables with said values. So there is not the conflict you are describing.

Perhaps, before you run your UPDATE, you can change the values of the relevant controls.