I have code to tic a specific checkbox as soon as you click on the button (New) but if I enter a new record by typing on the textbox and not by using the (New) button the checkbox is never not ticked...I thought I was on the right tracked by doing the following but it doesn't work:
Private Sub Games_AfterUpdate()
If Dirty Then Do
InCollection = True
DoCmd.GoToRecord , , acNewRec
End Sub
I also tried a Form_Current() then me.games.enabled = false with a cmdNew_Click() with a me.games.enabled = TRUE when clicking on the button but I have to click the button twice to take the field out of FALSE.
And I also tried FALSE as a default in the cmdNew_Click() code with an Else of TRUE.