MsgBox

  • Thread starter Thread starter Secret Squirrel
  • Start date Start date
S

Secret Squirrel

On my subform I have a checkbox that is driven by another control on my
subform. When a member is selected from my combo box this check box will be
checked if that member is active. What I want to do is have a msgbox appear
after a new record has been added to my subform so that the user will remind
the member that their account is not active. How would I set this up? I tried
putting this code in the after insert event of the form but it's not working.
Am I missing something?

If IsNull(Me!Member) Then
MsgBox "Reminder: Member is not active"
Else

End If
 
Assuming that Member is a Yes/No datatype, you should be checking whether
the value is False (No), rather than null, because a Yes/No field will
default to False, not to null. Try:
If Not(Me!Member) Then
...

HTH,

Rob
 
Thanks Rob! Works perfectly now!

Rob Parker said:
Assuming that Member is a Yes/No datatype, you should be checking whether
the value is False (No), rather than null, because a Yes/No field will
default to False, not to null. Try:
If Not(Me!Member) Then
...

HTH,

Rob
Click to expand...
 

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

Sum a field in a form 1
Counting multiple memberships 1
unbound combo box shows no value on open 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Subform causes Main Form to show the same record multiple times 9
Recalc Combo Box - F9 2
Sometimes GotFocus event doesnt occur on subform...strange 1
using groups for data entry 2

Back
Top