G
Guest
So here is the deal. I'm a basic user of access, I know enough of the basic
to be dangerous. At work, I have to do alot of visit requests for employees
to visit gov. installations and military bases. For as long as I can
remember, I have had to hand type all of the names, ssns, dob, clearance
level for each person, can get tedious especially when I have 30 people on
one document. So I made a Access table with all of the stuff I need, made a
nice simple form to enter data for new people, and I made a simple querie to
extract the stuff I need and a nice report in the proper letter format that I
need. Now, comes the problem. whenever I run the report, that is based on the
query, it pulls all of the data into the report. I know how to make a subform
in my main for, add a list box to it and select the multi select property. I
just don't know how to get those names that I have selected in the list box
to my report. Can someone please help me. Thanks.
Jeff
Williamsburg, VA
to be dangerous. At work, I have to do alot of visit requests for employees
to visit gov. installations and military bases. For as long as I can
remember, I have had to hand type all of the names, ssns, dob, clearance
level for each person, can get tedious especially when I have 30 people on
one document. So I made a Access table with all of the stuff I need, made a
nice simple form to enter data for new people, and I made a simple querie to
extract the stuff I need and a nice report in the proper letter format that I
need. Now, comes the problem. whenever I run the report, that is based on the
query, it pulls all of the data into the report. I know how to make a subform
in my main for, add a list box to it and select the multi select property. I
just don't know how to get those names that I have selected in the list box
to my report. Can someone please help me. Thanks.
Jeff
Williamsburg, VA