Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Posts
    23

    Unanswered: "Read Only" Query

    When you create a form based on a Select Query, how do you ensure that changes you make to that form don’t change the tables that underlie the query?

    Let me give you a better example. I’ve done a query of two tables, Customers and Addresses.

    I’ve created a query called Trips which has a form. With that Trip form I need to add additional fields as well as make changes to fields from the Customer and Address table query.

    What I don’t want is for the changes I make from the Trip Form to alter the default records from the Customer and Address tables.

    These changes are one time only.

    In essence I want to “lock” the Customer and Address tables. I want to be able to read the Customer and Address records, even copy those records, but not actually alter or make those changes permanent within the underlying records.

    I assume there is a “read only” feature for some fields.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by rlb2252 View Post
    I assume there is a “read only” feature for some fields.
    Yes - look at "read only" and "enabled" properties of form controls

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •