General discussion

  • Creator
    Topic
  • #2175495

    Access XP – Fields Can Be Locked?

    Locked

    by virgoan ·

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

All Comments

  • Author
    Replies
    • #3350749

      Reply To: Access XP – Fields Can Be Locked?

      by regg ·

      In reply to Access XP – Fields Can Be Locked?

      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.

    • #3350746

      Reply To: Access XP – Fields Can Be Locked?

      by virgoan ·

      In reply to Access XP – Fields Can Be Locked?

      This question was closed by the author

Viewing 1 reply thread