VBA to test and give a message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I do not know VBA . In my form when I click on Print or Preview buttons I
need the status of a specific field (which is a combobox in the subform) to
be tested. If that field is null then a message box should tell the user to
select one item in that combobox if it is not null then it should continue
with the normal operationof that button.
Thanks
 
If IsNull(Me.NameOfField) Then
MsgBox "The field is empty"
Else
' whatever code was already there
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Go to a Specific Record on a Subform 3
Excel VBA - Problem with Closing Print Preview 0
How to use setvalue to set form comboboxes to null 1
Update subform with combobox change on main form 1
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Testing Subform Records to make button visible 1
Need combo box to refresh when moving to new record 2017 1
Requery on a ComboBox gives ODBC error 2

Back
Top