Edits

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

How do you go about setting up an edit form without having the user access
the tables. I have forms built and each also has an edit form. I am afraid
since currently all the edit forms revert back to the table.
 
How do you go about setting up an edit form without having the user access
the tables. I have forms built and each also has an edit form. I am afraid
since currently all the edit forms revert back to the table.
Click to expand...

What do you mean by "revert back to the table"????

A Form is *nothing but a window*.

Data is stored in tables, and only in tables. If you base a Form on a table -
or on a query based on a table - and edit data on the form, you are editing
(and permanently changing) the data stored in the table. If you want a
separate editable copy of the data, you need to copy the data to another table
and edit *that* table (using a form, most likely).

Am I misunderstanding the question?
 
That's what I thought. Thanks

John W. Vinson said:
What do you mean by "revert back to the table"????

A Form is *nothing but a window*.

Data is stored in tables, and only in tables. If you base a Form on a table -
or on a query based on a table - and edit data on the form, you are editing
(and permanently changing) the data stored in the table. If you want a
separate editable copy of the data, you need to copy the data to another table
and edit *that* table (using a form, most likely).

Am I misunderstanding the question?
Click to expand...
 
Back
Top