Form/subform problems

Form/subform problems - Newbie

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jenatawp - 22 Mar 2007 17:22 GMT

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.

Signature

J. Shafer
AWP Industries, Inc.

Reply to this Message

Al Campagna - 22 Mar 2007 17:38 GMT

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.

Signature

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."

>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
[quoted text clipped - 8 lines]
>
> Best Regards.

Reply to this Message

jenatawp - 22 Mar 2007 19:11 GMT

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

Signature

J. Shafer
AWP Industries, Inc.

> jenatawp
> Make sure that the main form query RecordSource is based on just the Quotes table (the
[quoted text clipped - 19 lines]
> >
> > Best Regards.

Reply to this Message

Al Campagna - 22 Mar 2007 20:08 GMT

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.

Signature

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."

> 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
[quoted text clipped - 29 lines]
>> >
>> > Best Regards.

Reply to this Message