Creating a record when VBA changes contents of bound control

[dcdimon]

I have a control that is used to show whether the piece of equipment that is associated with the form is UP or DOWN. The control is bound to a field and has a default value from a DLookup expression. There's a button that can be selected to change the status (UP to DOWN, etc). However, when the entry is changed a new record is not created unless another control on the page is selected or the user clicks on the form somewhere.

99.9% of the time users will be filling in other controls on the form. However, there's a possibility that someone could change from UP to DOWN and navigate away. What I want to happen is when the status is changed a record gets created at that point. That will fire off some other vba I have that's tracking other data.

I'm running off a SQL server backend with an Access front end.

Any ideas?

Thanks.

[pbaldy]

From the sound of it, you need to move the code to create a new record to the button from wherever it is now.