Enable control on insert only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to disable or otherwise prevent data entry on a control when
updating, but enable when inserting?

before_insert doesn't work because it does not fire until data is entered.

on_current is possibility if there is a way to detect whether a form is in
insert or update mode.

Thx.
 
Try using the form's On Current event:

Me.SomeControl.Enabled = Me.NewRecord

HTH,
Brian
 
Back
Top