I am fairly new at some parts of access but I have a slight problem that may not be as bad as I think. I have been trying to build a simple form with several drop down boxes for the user to select items. each list has a selection wich are options to add to a base product. for example: Large desk base price is $500.00 the drop down boxes list types of options with that option price. like "cover option" you click on the box and choose from the list wich is located in a table with that option in one column and the price of that option in another. a selection like Marble top = $99.95 if he clicks on that option then once all the options have been chosen I made a button with a macro attatche wich colects all the selections he maid and sends it to a report with the option listed and the price. then the report adds all the options together and adds the base price to get a total figure. But what if He only choses 3 out of 5 options ? I dont want the other options to show up on the report if he did not select them. I hope this makes sence. I know I sound like an idiot but I have searched books and tutorials and have come up empty for the last 6 months there has to be a master out there somewhere... Please help me!!!!!!!!! Thankyou so much for your time!!!!!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.