S
sljack63
I modified the Customer Phone List macro and copied the option group
from the Northwind DB to a form I created in my database. The form in
my database is a single form, not a continuous form as in the Northwind
Database. It also allows additions and deletions. Everything works
great and the form will filter via the alpha tab selected and will also
display "ALL" records when the button is clicked. However, in the
macro is suppose to display a Msgbox on this condition:
[CurrentRecord]=0
My form wil not display this message box when a filter is applied that
brings up no records. Is it because it is a single form that allows
deletions and additions? How do I change the condition in the macro so
that a message box comes up to tell the user that there are no records?
I tried this, but it didn't work:
IsNull([GrievantLastName])
TIA
from the Northwind DB to a form I created in my database. The form in
my database is a single form, not a continuous form as in the Northwind
Database. It also allows additions and deletions. Everything works
great and the form will filter via the alpha tab selected and will also
display "ALL" records when the button is clicked. However, in the
macro is suppose to display a Msgbox on this condition:
[CurrentRecord]=0
My form wil not display this message box when a filter is applied that
brings up no records. Is it because it is a single form that allows
deletions and additions? How do I change the condition in the macro so
that a message box comes up to tell the user that there are no records?
I tried this, but it didn't work:
IsNull([GrievantLastName])
TIA