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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
User Sets Control Default Value 1
preventing record movement on Access form with navigation bar enabled 1
New Record Insert 2
Enabling Multiple Controls 4
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Enable/Disable Control 3
QBE inserts quotes instead of brackets around field names 2

Back
Top