Software

Ask something
Discussion Locked

Access XP - Fields Can Be Locked?

0 helpful
3 replies

by virgoan 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can some fields of my table be locked? I want to retrieve user to enter data for certain fields.

3 replies

by regg

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.

This discussion is closed to new replies.