Compare user entered date to date in table

[tuxalot]

I have a textbox, [Date of Injury] on [FrmMain] with a record source [TblEmployeeInju ry]. FrmMain is a tabbed form showing injury data for a given EmployeesID. I have a textbox, [Start Date] on a subform [FrmMain].[FrmDateHistory] with [TblDateHistory] as the record source. [Start Date] is entered by a user and saved to the table by clicking a save button on the subform. Both date entries are in Short Date format and entered by Date Pickers. I would like an On Click event to fire when the save button is clicked which would compare if [Date of Injury] and [Start Date] are equal. No other comparison is required. If they are equal, I would like a MsgBox to show, and after the MsgBox is closed the set focus would return to [Start Date].

I'm very new to Access so hopefully someone can assist with this.

Any help is very much appreciated!

[puppydogbuddy]

Add the following code to the end of the existing code for your save button.


'______________ _______________ _______________

If Me.[StartDate] = Me.Parent.[Date of Injury] Then
    MsgBox "Your message."
    Me.[StartDate].SetFocus
End If

[tuxalot]

Thanks pup! I appreciate the fast response.

Tux