Lock all the Fields on a Tabbed form

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

Guest

Hi All,

I have a order management program in which there is a tabbed form with many
fields. after the order has been posted to general ledger, I wish to lock
all the fields to avoid any user chanding the information again.

Could you please let me know how to prevent all the fields on the tabbed
form from being edited?

Thanks for your reply.

Best regards
Avir
 
Could you just set the AllowEdits property of the form to No?
Leaving AllowAdditions as Yes would permit new records.

If that's not what you want, you could loop through the Controls collection
of the form, examining the Parent of each control. The Parent will be the
form itself if the control is sitting directly on the form, it it will be
the page if it is on one of the pages of the tab control. So the contol is
in the tab control if:
Forms!Form1!Text0.Parent ControlType = acPage

Presumably you will then set the Locked property of the relevant controls.
 

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

Arrange fields on a form 3
tabbing deletes bound text fields 2
Form Suddenly Became Non-Editable? 1
Locking txt fields on a form 2
Opening form and going to a specific field in the middle of the from 1
Word Lock specific drop downs on a Word Document 0
Control if a form updates table 3
Form Field Update Error 2

Back
Top