Help creating a simple form

[mattmurdock]

Hey guys, I've been trying to make a form but with no luck. I'm pretty new to Access so frogive me for simple errors. I think this should be an easy solution though.

I have three tables- Size, Price, and Upcharge. Simply I need to create a form that lets the user select a size, which automatically fills in the price, and then select an upcharge.
From there, they insert a name, description and PIN # (on the same form), hit a button, and it creates a table that has all the info in a row, with a column for total price (price + upcharge).

I've attached the tables and a few things I've been messing around with. Can anyone give me some directions?

[Bob Fitz]

Can you attach a version of your db in mdb (A2003) format

[mattmurdock]

Can you attach a version of your db in mdb (A2003) format

Sorry I tried but I don't think its possible.

[Bob Fitz]

I have three tables- Size, Price, and Upcharge. Simply I need to create a form that lets the user select a size, which automatically fills in the price, and then select an upcharge.
From there, they insert a name, description and PIN # (on the same form), hit a button, and it creates a table that has all the info in a row, with a column for total price (price + upcharge).

I would create a table that will store the selected data. Create a form that is bound to that table. Create a combo box for each of Size, Price, and Upcharge. Bind each combo box to the relevent field in the forms Record Source. Use the tables that you already have as the Row Source for each of the combo boxes. Create a calculated textbox control on the form (or base the form on a query that has a calculated field) for total price (price + upcharge). Calculations should seldom be stored in a table.