Hi,

I've been creating a few forms - my first forays into this.
Previously I've used access for querying and writing reports; the data
having come from other databases and been imported in large chunks
into my access databases.

I've created a couple of forms. Some bound to a table, some with a
form and a subform. And a couple where the data source is a query
that selects from two tables, like this:

select tbl1.id, tbl1.lastname, tbl1.firstname, tbl2.textdata1,
tbl2.textdata2, tbl2.textdata3 where tbl1.id - tbl2.id ;

My form works just fine. All the fields in the query are displayed on
the form. I am using it to add, edit, and delete rows in tbl2. I do
not want to be able to change data in tbl1 though. I'm not quite
sure how to achieve that. A couple of time I've inadvertenly typed
into the fields for the tbl1 data and changed it. I only want to be
able to search for the tbl1 data; that is, look for all the data
associated with id 007, or lastname = Bond, but do not want to change
any tbl1 data, only change stuff in tbl2.

Any help appreciated,

Thanks.

Gilgamesh wrote:
In your tbl1 fields you could set the Locked property to True. If
Enabled and Locked are both True, you can enter the field, view the
field, but you can't modify the field.

For me, fields that allow input are sunken. Those that are locked/not
modifiable are flat. That provides a small visual representation of
fields that can be modified and those that can't. Locking it will
ensure it.

On Mar 22, 3:24*pm, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:
Thanks, that did just what I wanted.