Lock field after it has been updated via an other form

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

Guest

I have a form named 'Jobs' with the following fields: Job Number, Job
Description, Assigned to, Tasks, Cost and Completion Date. I have a second
form named 'Approval' with the following fields: Job Number, Cost, Cost
Center, BU Controller, Reviewed By and Approved By. The Cost field in the
'Approval' form is automatically populated if an user enter the Cost in the
'Jobs' form. (It is done via an update query). Is there any way to lock
(prevents change to) the Cost field in the 'Approval' form if it is using the
value from the 'Jobs' form. I still want to maintain the ability to update
the Cost field if it is blank/not update.

Thanks,
Mike
 
Mike

There are two properties of controls on forms you'll want to check out --
"Enabled" and "Locked". Access HELP lists the various combinations for
these two, and the effect of each.
 
Back
Top