A
access wiz
I have a simple form in which I have added Command Buttons which go to the
previous record and the next record. I have also added a condition to Go To
Next Record/Previous record that alerts me when I haven't contacted the
person in 30 days:
MsgBox
[Forms]![New Millimax]![last_contact]<=Now()-30
The annoyance of this is when I am scrolling through the records I
constantly keep getting the pop notice which is quite helpful at first but
not if I am not looking for that information. I want to create a option
button which turns this searching for last contacted off. I have tried the
IIf statement and don't believe I am doing it correctly. Does anyone have an
answer?
previous record and the next record. I have also added a condition to Go To
Next Record/Previous record that alerts me when I haven't contacted the
person in 30 days:
MsgBox
[Forms]![New Millimax]![last_contact]<=Now()-30
The annoyance of this is when I am scrolling through the records I
constantly keep getting the pop notice which is quite helpful at first but
not if I am not looking for that information. I want to create a option
button which turns this searching for last contacted off. I have tried the
IIf statement and don't believe I am doing it correctly. Does anyone have an
answer?