Locking a few field

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

On a form if i have a tick box 'OrderComplet"

I would like some code that will lock the following text boxes if
"ORderComplete" is ticked

txtOrderNumber
txtORderDate
txtTotal
txtDespatchDAte


Thanks
 
I would add "LockComplete" in each of the tag properties of these controls.
Then use code in the after update of the tick box like:

Dim ctl As Control
For Each ctl in Me.Controls
If ctl.Tag = "LockComplete" Then
ctl.Locked = Me.OrderComplet
End If
Next
 
In addition, you might want to call the after update code in the On Current
event of the form.
 

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

Query referencing a field without a value 5
Yes No Combo Boxes Queries Filtering as 0 and 1 Instead....work ar 3
Working with Y/N checkboxes 1
How to refer to a control on a child form in the on close event of the master fo 3
Locking txt fields on a form 2
setting box back to null 3
Text box contains #Error regarding sum value 4
Check box teaser 2

Back
Top