Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

list box selection form to reoprt "help"

list box selection form to reoprt "help"

list box selection form to reoprt "help"

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!!!!!

RE: list box selection form to reoprt "help"

I have a similar situation. If the options you are selecting from all come from the same table you could try this.

Create a list box on one side of your form that displays the choices. Then on the other side of the form have an empty list box to hold the selected items. Have the user do somthing like double click the items they want and then the code adds this item to the other list box. After they are done selecting the items all you need to do is look at the selected items list box in your report. There is a help section for this type of procedure in Access. If you need more help just ask.

John A. Gilman

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close