Form based on Query

R

RTimberlake

I have a form that is based on a Query. Since I have based the form on the
query I can no longer enter information on my form. I am stumped. How can I
base a form on a query and still be able to enter info on my table?

rebecca&payh.org
 
E

Eric D via AccessMonster.com

Can you provide the query?
If your query is based on more than one table, you will have problems
updating. If based on one table, you should be able to add/edit records from
the form.
 
R

RTimberlake

What do you mean can I provide the query? Do you want me to e-mail it to you?

The query is based on multiple tables. Perhaps that is where my first
mistake was.
Thanks for your help.
 
M

mutlu

what type of query did you use and you said "I can no longer enter
information on my form", however you said "enter info on my table" at the
end. if you give more info I'll try to help you
 
R

RTimberlake

Sorry about the confusion. In my frustration I did not state my problem very
clearly.
You asked "What type of query did you use?" I used the query builder. So I
guess that it was just a regular query. I have 9 tables that are linked by
Social Security Number. I have build my form and based the form on the query.
When you open the form you cannot enter information on the form.
The confusion came when I stated that I needed to be able to enter info on
my table. I need to be able to enter the info on the form and have it saved
on my tables.
I hope that this has cleared up the problem.
Thank you for your help.
Rebecca
 
M

mutlu

I mean that you used a select, make-table or update query. did you use Social
Security Number table while building your query?
 
R

Rick Brandt

RTimberlake said:
Sorry about the confusion. In my frustration I did not state my
problem very clearly.
You asked "What type of query did you use?" I used the query builder.
So I guess that it was just a regular query. I have 9 tables that are
linked by Social Security Number. I have build my form and based the
form on the query. When you open the form you cannot enter
information on the form.
The confusion came when I stated that I needed to be able to enter
info on my table. I need to be able to enter the info on the form and
have it saved on my tables.
I hope that this has cleared up the problem.
Thank you for your help.
Rebecca
Click to expand...

Many queries don't allow edits. A query with 9 tables as inputs would
almost certainly not allow updates. Except for occasional two table queries
that include a lookup value it is not a good idea to base editable forms on
multi-table queries. Better practice is to use sub-forms.
 
M

mutlu

is it possible to send the file "[email protected]", because I realy
don't understand the problem. It should have to work when you do the form and
at the same time add all new records into the table
 
R

RTimberlake

How many tables can you put on a query? I can do some of the tables as
subforms, but I will still have 4 tables that cannot be done as subforms.
 
R

Rick Brandt

RTimberlake said:
How many tables can you put on a query? I can do some of the tables as
subforms, but I will still have 4 tables that cannot be done as
subforms.
Click to expand...

Read the help topic "When can I update data in a query" as there is not a
cut and dried answer to this. Every query is different, but basically as
soon as the structure of the query makes it difficult for Access to know
where (which table) the edits should go, then the query reverts to
read-only. Sometimes the query design can be tweaked to make it editable
again, sometimes not.
 
Top