07-06-2001, 04:19 PM
I have a form. In that form I have fields txtIssueResolution and txtIssueResolutionDate. If txtIssueResolution is not null, then I have to make sure txtIssueResolutionDate is filled in before the record is updated. I have a save button. I've tried to put code there. The problem is, I need some code. Maybe even advice...
07-06-2001, 05:09 PM
This will work in Access 97, but 2000 cann't be too different
Private Sub save_button_Click()
Private Sub Form_BeforeUpdate(Cancel As Integer)
if isnull(txtIssueResolution)=false then
if isnull(txtIssueResolutionDate)=true then
msgbox "there is not value in txtIssueResolutionDate"