Form based on a query

Marbinski

Registered User.
Local time
Today, 01:37
Joined
Aug 24, 2004
Messages
45
I have a form based on a query. I have a txt box that has a field deriving from a field in the query. If someone were to alter that data in that text box, will the data in the original table be changed or just the data in the query?? Thanks for your input.
 
Think of a SELECT query as an alternative way to display the data that is in (a) table(s). The data does not exist in both places, the table and the query, it is in the table. If your query is Updateable, then any changes to the data are made in the table, whether it be from a query or a form.
 

Users who are viewing this thread

Back
Top Bottom