UNdo if date is null

[theinviter]

Dear Guys;
i need a help.

i have a form to filter to fill , if user did not select date first and he add any value them , i want msgbox to show text message and cancel the data entered;

i tried this but not working.

Private Sub TOTAL_PHYSICAL_COUNT_AfterUpdate()

If IsNull(Date_From) Then
MsgBox " Please Add Date Range"
Me.TOTAL_PHYSICAL_COUNT.Undo

Else

TRT= Text140
End If
End Sub

 

[June7]

Are these UNBOUND controls just for input of filter criteria?

If these are BOUND controls for input of data to record, use form BeforeUpdate event for data validation of record.

 

[theinviter]

Are these UNBOUND controls just for input of filter criteria?

If these are BOUND controls for input of data to record, use form BeforeUpdate event for data validation of record.

yes its bound to record in data. but i tried before update , the same problem , if i type any number and date field in null it will be added to record.

 

[June7]

Need to provide that attempted code or your database.

https://docs.microsoft.com/en-us/office/vba/api/access.form.beforeupdate-event