forms problem!

[Mascotte]

Hi,

I have a table, a query and a form but everytime i update my form. Only my table is updated but not my query. Why is this? Can i update both the table and the query when i update my form? Please advise.

Thanks.

 

[boblarson]

I think you aren't quite understanding how things work in Access.

A table stores data. A query displays data from a table or from other queries (which get their data from tables). A query does not store data, nor does it get "updated." It will display the data in the table, if the query is "requeried" after entering the data in the table it is based on.

What is this query for?

 

[John Big Booty]

Could you please explain in step form what is happening and what you would like to happen.

Is the query collecting data from the table and populating the table? or are you doing something else?