Hi everyone! I am sure this question has been asked and answered before but I could not find it through a search. This is most likely because I don't know the proper terminology to ask my question.
What I am trying to do seems incredibly simple but I have been stumped. I don't know VB but I am smart enough to be able to cut and paste and change field names with those from my own database, which I don't even like calling a DB because it's one table with 4 fields.
I am trying to create an order form in Access 2007 where a user sees a list of about 100 rows of data and clicks on the ones they want to order. At the bottom of the form I want a button that when clicked displays the rows selected. So far I have a form that has a multiselect list box set to simple and that part works but I don't know how to pass the values selected to a report or query or whatever I need to pass it to so that I can display those selected values.
I saw an example of the code to pass multiselect values on microsofts website but I could not implement it correctly. If anyone can answer my question without using to many technical terms I would appreciate it or if you know of a DB I could download that has this already in it that would help as well so I can see what is being done.
Thanks!
What I am trying to do seems incredibly simple but I have been stumped. I don't know VB but I am smart enough to be able to cut and paste and change field names with those from my own database, which I don't even like calling a DB because it's one table with 4 fields.
I am trying to create an order form in Access 2007 where a user sees a list of about 100 rows of data and clicks on the ones they want to order. At the bottom of the form I want a button that when clicked displays the rows selected. So far I have a form that has a multiselect list box set to simple and that part works but I don't know how to pass the values selected to a report or query or whatever I need to pass it to so that I can display those selected values.
I saw an example of the code to pass multiselect values on microsofts website but I could not implement it correctly. If anyone can answer my question without using to many technical terms I would appreciate it or if you know of a DB I could download that has this already in it that would help as well so I can see what is being done.
Thanks!
