My new question is not displaying I had to go to new comment

[Guest]

I designed a database for taking customer orders that will create a packing
slip. I now want to add the price of the item to the packing slip. I have
added the price to my “products table†and my “orders detailed†table, which
are related one to many. Now I go to my “Order sub form†in design view and
drag the price object from the “orders detailed†table list to the “Order sub
form†and save the form. When I now go to the “Order form†that contains the
“Order sub form†and select a product in the sub form the price object is
blank. What am I forgetting?

 

[Wayne Morgan]

Check your Orders Detailed table and verify that there is a value in the
desired field. If so, then verify that the Control Source of the new textbox
shows this field name. I am assuming that the Record Source for the subform
is the Orders Detailed table or a query based on the table. If you are using
a query, make sure that you add this field to the query also or it won't be
available to the form.

Why is the price in both tables? Could you just use a calculated control on
the subform with the DLookup() function to get the value?

FYI, as far as the second post, these newsgroups get fairly busy and it
isn't unusual for it to take 10 minutes for a post to show up. Even if the
group your posting in isn't that busy, there are other groups on the same
servers. Your second post was 5 minutes after your first one (yes, it showed
up).

 

[Guest]

Sorry about that, I can not get my New-Question to work only New comment. So
I posted 2 times not knowing it takes up to 5 min. to post. I did not realize
it would post as a question.