Access - Force Form Refresh on New Record
- by gamerzfuse
Let me set the stage here a bit:
I have an Access project with various buttons, triggers, macros, etc.
I needed an Appointment Date field to only show when the button APPOINTMENT MADE is toggled ON. This works great.
The problem arises when you submit a form with the APPOINTMENT MADE toggled. Once the record is inserted, the Access file clears all fields, but leaves the Appointment Date enabled, when it should be disabled by default.
I have tried the Current, Load, Before Insert, After Insert and many other options on the FORM properties. Am I missing a simple way to force a refresh so the field goes back to it's default DISABLED?
Thanks in advance!