I have code that is in the On Current event of the form to check to see if it is a new record or not. If it is a new record, sub forms are disabled as it would cause an error if the parent record wasn't formed yet.
Usually, as soon as someone types on letter, the Form automatically becomes not New, and thus the embargo on the subforms is lifted.
However, I seem to be running into a problem that on a record I have a command button that will copy certain info to create a new record. Even though that data is entered and a new record ID is created, it is almost as if the Me.NewRecord is still returning true and the embargo is not lifting.
And now, it seems to be happening even when I am not copying, but strictly adding a new record. So when is this property checked?
Usually, as soon as someone types on letter, the Form automatically becomes not New, and thus the embargo on the subforms is lifted.
However, I seem to be running into a problem that on a record I have a command button that will copy certain info to create a new record. Even though that data is entered and a new record ID is created, it is almost as if the Me.NewRecord is still returning true and the embargo is not lifting.
And now, it seems to be happening even when I am not copying, but strictly adding a new record. So when is this property checked?
