I have a textbox that is to be hidden on a form that uses the Count() function to count the rows in the form's recordset.
Using the On_Load event, I check to see if the value of the textbox is greater than one, attempting to change the caption of the button to either say "Add Record' or "Add Duplicate Record"
If txtRecordCount.Value > 1 Then
Me.btnAdd.Caption = "Add Duplicate Record"
Me.btnAdd.Caption = "Add Record"
No error is produced, and the event is correct as I can debug through it with "txtRecordCount.Value > 1" however nothing happens.