Unanswered: Need help with creating a form (newbie)
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 direction?
Hi Steve- thanks for the message. I tried putting in the code as you described but it never worked. I was hoping you could describe how to do it with my dB attached. Any help or directions would be greatly appreciated- Thank you!