set the following code on the form's Current event, as
Me!CommandButton.Enabled = Not IsNull(Me!AutoNumberField)
that will take care of the command button as you move from record to record
in the form. but enabling the button immediately after the Autonumber is
generated in a new record is a bit more problematic. i tried using the
form's BeforeInsert event, and also its' Dirty event; in both cases,
apparently the autonumber is generated immediately *after* the code runs, so
it does no good.
if the user *always* enters data in the same control *first*, in a new
record, you could add the above code to the control's BeforeUpdate event.
but if that's not the case, the best you might be able to do is to either
add code to every control's BeforeUpdate event (clunky) or settle for
enabling the command button when the new record is saved, by adding code to
the form's BeforeUpdate event.
hth
