T
TotallyConfused
I have the following on a click event on "Followup" command button. On
clicking this button it open a param form. It looks at pts assoc with doc.
There maybe more than one pt. If the "appt" or "followup" field dates are
null it will open form to enable to enter info reg pts assoc with doc.
However if "appt" and Followup is filled with a date then that particular
form will not open for that pt. which works fine. However, if there are
more than one pt. and "appt" or "followup" has a date on the first pt then
when I click on the "Followup" command button will not open form at all. Can
someone help with this please. How do I fix so that even if a date is in
"appt" or "followup" fields for first pt for will open for 2nd or 3rd pts.
Thank you.
If IsNull([Appt]) And IsNull([Followup]) Then
DoCmd.OpenForm "NoticeForm", acNormal, , "[DocID] = " & Me![DocID], ,
acDialog
End If
Exit_Followup_Click:
Exit Sub
clicking this button it open a param form. It looks at pts assoc with doc.
There maybe more than one pt. If the "appt" or "followup" field dates are
null it will open form to enable to enter info reg pts assoc with doc.
However if "appt" and Followup is filled with a date then that particular
form will not open for that pt. which works fine. However, if there are
more than one pt. and "appt" or "followup" has a date on the first pt then
when I click on the "Followup" command button will not open form at all. Can
someone help with this please. How do I fix so that even if a date is in
"appt" or "followup" fields for first pt for will open for 2nd or 3rd pts.
Thank you.
If IsNull([Appt]) And IsNull([Followup]) Then
DoCmd.OpenForm "NoticeForm", acNormal, , "[DocID] = " & Me![DocID], ,
acDialog
End If
Exit_Followup_Click:
Exit Sub