Form/subform problems - Newbie

J

jenatawp

I am in the process of building my first database for the purpose of tracking
quotes. On my form, I am tracking the customer information and quote #, and
on the subform, I am tracking the line items for the particular quote #. I
haqve successfully linked the two, but now it will only allow me to add
records to the subform, and not the form.

I am really unsure as to how to correct this. Can someone please direct me
on how to correct this issue?

Thanks in advance for your assistance.

Best Regards.
 
A

Al Campagna

jenatawp
Make sure that the main form query RecordSource is based on just the Quotes table (the
One). Do not include the QuoteItems (the Many).
When you open the query behind the Quote form, can you manually edit the fields. If
Not, then there's a problem with that.
Also, make sure that (while in development) Allow Edits for the form is Yes, and all
editable controls on the form are Locked = No.

Other than that, with the information given so far, it would be difficult to pin down
the problem.
If the RecordSource for the form is editable, the form will be.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
J

jenatawp

Thank you, Al. Hopefully, this will get me going. I will have to go back
and build a query for this - my form is built directly off of my tables. I
think that was my downfall.

I appreciate your assistance, and you quick reply.

Jen
--
J. Shafer
AWP Industries, Inc.


Al Campagna said:
jenatawp
Make sure that the main form query RecordSource is based on just the Quotes table (the
One). Do not include the QuoteItems (the Many).
When you open the query behind the Quote form, can you manually edit the fields. If
Not, then there's a problem with that.
Also, make sure that (while in development) Allow Edits for the form is Yes, and all
editable controls on the form are Locked = No.

Other than that, with the information given so far, it would be difficult to pin down
the problem.
If the RecordSource for the form is editable, the form will be.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
Click to expand...
 
A

Al Campagna

Jen.
I'd lije to know what you finally find out was the cause.
It's pretty rare to find a form based on an actual table... it's usually a query, where
you can sort and criteria as required.
The query can be just... all the fields from a table, but sorted.
Also, you don't need to create and "save" an standalone query, just click the (...) on
the RecordSource for a form, taking you into query design mode, adding the table and all
the fields, and sorting as desired.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

jenatawp said:
Thank you, Al. Hopefully, this will get me going. I will have to go back
and build a query for this - my form is built directly off of my tables. I
think that was my downfall.

I appreciate your assistance, and you quick reply.

Jen
Click to expand...
 
Top