referencing form in datasheet view

[hirenJ]

Hi all, I have a form that contains a subform that is set to Datasheet view ---

I have a boolean field called CONTROL in this datasheet. How do I reference this field in the datasheet so that when the user changes the value of CONTROL in the datasheet, a msgbox appears?

any ideas?

thanks

Hiren

 

[AlexMidd]

View the subform in design view, you should then see the controls underlying the data sheet. Select the one for the Boolean value and view its property sheet. In here you should find the AfterUpdate event. Go to the code builder for this event and put a MsgBox function in there. When the value is changed, the messagebox should popup.

If you want a warning to come up BEFORE the field is updated (so that you can cancel the change) use the BeforeUpdate event instead. Have fun! )

Alex Middleton