need help printing some values in access

[versuviusx]

ok so i'm trying to print some values in access. i'm really new with it so i just need a little help.
i have a dropdown list and i have put in my values for it manually by making the source a value list and then just manually putting in my values when making the table. so i have this form and i found a print icon for printing records. here is what i want it to do. if the user selects a value that is from the value list i want to print out 3 lines of text along with it.
so for example lets say the user selects:
"GA" in the drop down list.
i need it to print out 3 lines
dawer= gulf american
drawer = Gulf American
DRAWER = Gulf American

how can i get these 3 lines printed out?

 

[Dennisk]

Step 1 is to create a query. In the criteria grid you can reference the list on the form using this notation

Forms!YourFormName!YourListname

Step 2. When you are happy with the results use the report wizard to generate the report with the query your created in step one as the report recordsource.

 

[versuviusx]

here is the code for the print icon
so basically i have the code nulled out but
i think there is a way when i click on the print button i can control
what i want to print.
i need the code for example for something that would output something like
Drawer = *Gulf American*

and i was thinking that the code below would do it but it does not work.



Private Sub CmdPrint_Enter()
'Drawer =' + '*'+ me.Drawer_Name.Value +'*'


End Sub

 

[Dennisk]

Use the command button wizard to create a button that will open a report for you.