CODEWITHSUNDEEP
vbams-access
Mike
Mike

Reputation: 1011

Is there an equivalent to an "On Record Changed" event for Access?

I am trying to set permissions for my form fields (continuous form) and permissions need to be re-evaluated every time a different record gains focus/selection. Right now the only way I've found is to have an OnFocus event for each editable control, but there's gotta be a better way...

I've already tried MouseMove, OnClick, etc. but they don't seem to work when clicking/moving from a control in one record to the next without clicking over empty space first. Also MouseMove seems to have a limit to how frequently it responds.

I would also appreciate something equivalent to an "On Focus Changed" event, if "On Record Changed" is not possible.

Upvotes: 1

Views: 5456

Answers (2)

Guy Cohen
Guy Cohen

Reputation: 759

The event you are looking for is : Form_Current

Upvotes: 2

Beth
Beth

Reputation: 9607

Try OnCurrent, or maybe OnDirty, and can also try OnAfterUpdate. I usually put stops in all of the candidate events when I'm not sure which one to use. There are differences, but running your application and seeing when the events fire can help you decide which one to use.

Upvotes: 2

Related Questions