Thread: Compare user entered date to date in table

I have a textbox, [Date of Injury] on [FrmMain] with a record source [TblEmployeeInjury]. 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!