Subform Data entry problem

  • Thread starter Thread starter fabianjones
  • Start date Start date
F

fabianjones

I have a main form and on the main form I have a tab control with
several subforms.

I altered one subform in the following manner:
- Originally, it was linked to a table with a simple query: SELECT *
FROM myTable
- I had to build a query and now the data is being pulled from the
query: SELECT * from myQuery

Now, when I try to change the information, it is not allowing me to do
so. Is it because I am now grabbing data from the new query (myQuery).
Will I now have to grab data from both the query and the original
table? (myQuery and myTable)? Any help would be appreciated. Thank
you.
 
The query (myQuery) is structure such that it isn't updateable. If you open
the query, can you change information?

If not, you can look up in Help about updateable queries. It will list the
reasons why it isn't updateable. It may just be a minor change to make it
work.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Data Entry Setting 0
Parameter Value error in a Subform 0
ADO Execute pass-thru query inserting data into local table 1
Beginner question - getting the values of a query into two variables 1
Access2000: Update query 6
Q:docmd.openquery with parameter 5
Transferspreadsheet - insert rows with no header 1
"3035: System resource exceeded." - Append Query w/in Transaction 1

Back
Top