Full line of product info in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am relatively new at programming in Access and need to create a purchase
order that lists the product, product name, number of products in a case, the
cube and weight of the case. I need to keep a running total of the cube and
weight columns as the buyers need to know how much room remains in the
shipping container.

I created a form and subform to do the job, but whenever I run the form, it
leaves out the product description, plus I can't choose the product ID from
the drop down list. The subform is connected to the products table and each
field in the form matches the properties of the corresponding field in the
table.

Do I need to do some VB in order to have the form work? I have not had any
experience with VB at all, so I am at a loss as how to continue. My
supervisor is chomping at the bits to get this program running. Any help
would be greatly appreciated.
 
If you build your subform and using the wizard place that subform on to the
main form it should ask you the connecting fields that are alike in both
tables i.e. possibly a ID of sorts that is the same in both tables.

Once this is done it sets the link childs and master fields and it should
rotate as you desire.

VB is not normally necessary in this case.
 
I rebuilt the form and subform and used the wizard as you suggested, but it
did not ask me what fields were alike (I did,however, make a relationship
between the tables beforehand, so that may be why that step was missing).
When the pop-up window asked for the link childs and masterfields, I'm not
sure what to put. In the Child I put the "like" field, and the master
dropdown had the table fields which I used the same "like" field, but now I
don't even get any of the products in the product ID combo drop down list. I
even tried using the product ID field in the master feld link.
 
If you have not already corrected this problem ZIP the db with only a few
records in each table and send it to me I will review it and see what I can
find that is evidently missing..

Send to (e-mail address removed)
 
Back
Top