Need to create a subform, can't figure out

[mattmurdock]

Hi guys I have a very small db here with 4 tables and a form.

I have attached my db.

In my form there is a combo box to select "Size".
What I want is for when the size is selected that the corresponding "Price" auto fills.


I think I have to use a subform for this but I'm not sure.

Don't worry about Upcharge or anything, I'm just stuck at this for now

Any guidance or directions would be greatly appreciated, thanks!

[Robeen]

1. Table NDP doesn't have any data.
2. Your Form doesn't have a 'Price' field.
3. I don't think you MUST have a sub form.
But - you will need a way to connect the Size to the Price. Right now, I am not seeing how that is possible with the tables you have.
In other words . . . can you tell me - using the DB you uploaded - how you connect Size -> to Price?

You can put a Price field on your Form, and once a Size is selected . . . you can write some simple code to populate the Price field. Again, I don't know in your database, so I don't know what connects the Size to the Price.

Give us some more to go with & we can figure this out.

[mattmurdock]

Hi, thanks for your response and help!

I have attached a more updated version of my db- hope its improved. I just added the prices to the Can table.

Another problem I am having is that I have added a button on my form which sends the info to the table NDP, from there I have a query (Query3) that has all the info plus Total Price and discounted price. BUT the info being sent is the ID number, not the "16oz" or "70" or "5". Any help?

Where can I find and/or how do I write the code (I'm experienced to vba in excel) to populate the price field?