Form based on Query

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

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.

RTimberlake wrote:
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


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200508/1

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.



"Eric D via AccessMonster.com" wrote:

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.

RTimberlake wrote:
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


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200508/1

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

"RTimberlake" wrote:

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

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

"mutlu" wrote:

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

"RTimberlake" wrote:

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

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

"RTimberlake" wrote:

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

"mutlu" wrote:

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

"RTimberlake" wrote:

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

I used a select query. I used SSN both in relationships and in my query.

"mutlu" wrote:

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

"RTimberlake" wrote:

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

"mutlu" wrote:

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

"RTimberlake" wrote:

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

RTimberlake wrote:
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

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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

is it possible to send the file ", 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

"RTimberlake" wrote:

I used a select query. I used SSN both in relationships and in my query.

"mutlu" wrote:

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

"RTimberlake" wrote:

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

"mutlu" wrote:

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

"RTimberlake" wrote:

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

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.

"Rick Brandt" wrote:

RTimberlake wrote:
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

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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com