Prompt in form

[IanT]

I want a message to appear if no data is recorded in a field. The message is to appear when the field is out of focus. Can anyone help!

 

[Hayley Baxter]

create a macro called msgbox then in the properties behind your combobox add this macro to not in list event.

Hope this helps

 

[wh00t]

Here's a basic code that'll do it

Private Sub ProductName_LostFocus()

If IsNull(FieldName) Then
MsgBox ("Field is blank, you must enter data"), vbExclamation
End If

End Sub