Conditional Macro to add MsgBox when Subform Field is blank

[chasm58]

I have a form with a linked subform.
The subform is populated from a query to a table with a field that may or may not be unpopulated.
I want to pop up a message when the subform is being populated from a combobox when this field is unpopulated.
I think I need an after update event on the subform.
Or, does the macro have to reference the field from the table from which the query is looking for it?


Any help would be appreciated.

[aytee111]

The event occurs when the combobox changes, so that would be your AfterUpdate. Where is the combobox, on the subform or on the main form? That would determine where you would look for the value - in the first case you can look at the value on the subform, in the latter case you could do a dlookup on the subform's recordsource.