Prompt User to enter a value in a field if left blank

[Guest]

I need the user of a form to get prompted if a comments field on the form is
left blank when a specific option is chosen from a drop down menu.

Example:
i have a combo box with 3 options
A) B) C)

Well, I if option "A" is selected, i need the user to enter information into
the comments field prior to exiting or moving to another record. How can i
prompt the user prior to exiting the record, when option "A" is selected that
information in the comments section is needed??

Any help is appreciated Thanks

 

[Guest]

Hi,
use the forms before update event:

If Me.YourCombo.Value = "A" AND IsNull(Me.YourMemoControl) Then
Cancel = True
MsgBox("Need something in the memo field")
Me.YourMemoControl.SetFocus
End If

HTH
Good luck

 

[Guest]

Method or Data Member not found for .SetFocus
any suggestions?

 

[Ron2005]

sounds like the name you are using for the comment field is
mis-spellled.