General discussion

Locked

Access XP - Fields Can Be Locked?

By Virgoan ·
Can some fields of my table be locked? I want to retrieve user to enter data for certain fields.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Regg In reply to Access XP - Fields Can Be ...

You could use two queries where one has the fields to be locked and set to read only, and the other the fields not to be locked set to be updatable, and then use a third query to combine the results of both, using this third query as the record source for the input form.

Or, you could simply just lock the input boxes on the form setting the property on the data tab of the properties page to locked/disable.

Collapse -

by Virgoan In reply to

got it! thanks so much.

Collapse -

by Virgoan In reply to Access XP - Fields Can Be ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums