Errors on Subform -- too much info

[jwrnana]

I have an Order Entry database from the access templates.

I have a table Orders and a table Order Details. Orders primary key is
Order ID. Order Details is linked to this table using 1 to many -- Orders
to Order Details (OrderID in both tables).

I inserted a subform using Order Details into the Orders form. However,
when I open the form, the subform contains ALL information for ALL
customers. What did I do wrong?

Thanks
JR

 

[Guest]

Hi JR
You did not specify the link. On the form in design view, go to subform
properties - data - Link Child fields and Link Master Fields - Use the build
button to put Order ID in there. THis will do it

Barb

 

[jwrnana]

Okay - can you tell I am a novice. I think I understand and then I get
lost.

I opened the main form in design view, but do not see subform option. I
opened subform in design and again I cannot see Link Child fields and Link
master fields. What am I missing?

Thanks in advance

 

[Guest]

Hi JR
Open your main form in design view. You'll see a rectangle in the middle of
it where your subform resides. Right click on this rectangle(right on it not
in the middle of it), (it will have a name like subformLink or something
similar - go to properties - then data. On data tab you'll see lines like
Child Link -right click and go to build. In there you'll just match the link.

Barb

 

[jwrnana]

Barb -

Did as you instructed. I right click and go to properties, but no child
link. It still reads as a form not a subform.

I created both forms and then drug the "subform" onto the main form. How do
I correct this?

JR

 

[jwrnana]

I Got IT !!!!!!

Thank you so much.
JR

Barb -

Did as you instructed. I right click and go to properties, but no child
link. It still reads as a form not a subform.

I created both forms and then drug the "subform" onto the main form. How do
I correct this?

JR
key

 

[Guest]

Hi JR
Before you do this copy your database and work on a copy. Open your main
form in desing view and cut (delete) subform. Use a wizard to insert subform.
In your toolbox make sure your wand is clicked in, one of the options in a
toolbox is a subreport/subform tool. Just insert subreport and let the wizard
take over. One of the first things he'll ask is if you want to use an
existing form - sure, and then he'll ask you how to link it to the main form
- just point it to the order ID.Let me know how it went.

Barb

 

[Guest]

welcome to the club

barb

I Got IT !!!!!!

Thank you so much.
JR

 

[jwrnana]

Barb - I was able to see child and master links. However, I now have
another problem.

On the main form, beneath the subform, are my subtotals, tax, discount,
freight, and total amount. I am getting 'Error #' in the fields that get
their total from the subform.

suggestions please.
JR