how do I lock a field in a form and use for look up value only?

[reggiea]

How do I lock a field in a form, yet still be able to look up value in this
field?

 

[Jeff Boyce]

Could you define your terms a bit more? I'm not sure what you are trying to
accomplish...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[John W. Vinson]

How do I lock a field in a form, yet still be able to look up value in this
field?

What's the form's Recordsource? Where is this field? What will you do with it
when you look it up? More info please!

 

[John]

I think I understand the question and why. I have the same question. I have
several support tables that are used to supply data for lookup fields in the
main program tables.

I would like to lock the support tables to prevent the data from being
accidently corrupted by less experienced users. Locking the data sounds like
the right way to protect it. Still not sure how to do it though.