Help with creating a report!!

[MnM]

I know pretty much nothing when it comes to Access reports, I can use the Wizard and that's about it. So I am needing some help on how to create a particular report. I have a variable that comes from a combo box and what I need is a report that gives me all the information about that variable. For example if you selected the Last Name "Smith" from the combo box, Smith would be stored in the variable LName. Say there is a table called Information and in Information would be last name, first name, address, ect.. Now there could be more than one Smith in that table so what I want is a report that will print out all the data where the Last Name in the Table Information = Lname. I'm sure this is possible in some way. Isn't it???

 

[DougP]

Very easy

Create a query that does want you want returns Lanem Fname Address etc.
It can look at the combo box on your form for the LName Criteria

Like so
=forms![yourform].form!combobox1

then create a Tabular report based on that query and save it.
then come back to your form and create a button that opens that report. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[MnM]

I'm getting there!! But I have one slight problem I have a form on a form and the combobox is on the 2nd form so I'm not sure how to write the query. I tried
=forms![operators lube]![test2].form!combobox1 but it prompts me for the data. Any ideas?

 

[CosmoKramer]

Try putting brackets around combobox1:

=forms![operators lube]![test2].form![combobox1!]

 

[MnM]

Access put brackets around it automatically. I just didn't put them in the above because I didn't type it with the brackets....Sorry. Thanks for the help though.

 

[CosmoKramer]

Is test2 the exact name of your subform, or did Access append "subform" to the title??

 

[MnM]

it's named test2 I have another form in test2 and it have the name subform in the title....however I've changed things I've taken my form (test2) and done away with it and just put that information in my original form (operators lube) and my query is working now. But thanks for the help!!!