Hi friends :),

 I created an DB in that i have created an from with combo box the combo as the data from an table i am try to generate the report by using that combo box , I have created the query for that report and rep view for that report , in the from i add command button name report view . i planned to kept as by selecting the data in the combo box and when clicking the button the report preview to disply . I use "Open.Report" code for that report which is not supporting . As i am new ot VB, friends pls help me to make the report. Is it possible for me to generate the rport in the switch board by which i desire.'
pls help me,
 I am waiting for ur reply,.:D

 Bye ,
 Pap

Hi friends u can sent the clarification through E-mail : anukagni@gmail.com

Bye
Pap
Today's Mess (Thirukural)
"Learning is wealth none could destroy
Nothing else gives genuine joy"

To open the report filtered down by what you select in the combobox, use the OpenReport method as follows

DoCmd.OpenReport "ReportName", acPreview, , "[FieldName] = '" & Me.cboComboBox & "'"

Where you replace my fake names of ReportName, FieldName, and cboComboBox with your real names.

FieldName is the name of the field in your query you want to set during runtime.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi,:)
Gerg thanks for reply i had tried that but i got an mess that Run-time error "Object deosn't support this property or method"
Pls clarify the mistake i had done in the DB .,

'OpenReport.
    DoCmd.OpenReport (Query1,[acViewPreview],[Issue to whom] "'" & Me.EmployeeName & "'")
iam trying to finish the mistake ,but i am new to the DB pls
thanks again

Regards,
Pap:)

Today's Mess (Thirukkural)
"To meet with joy and part with thought
Of learned men this is the art" (2:1:2:394)

Hi Greg ,

 I got the function correctlly , thanks for ur help,
 and now i have posted an new topic pls give me an posotive reply on that Issue.

 Bye,
 Pap
Today's Mess (Thirukkural)
"To meet with joy and part with thought
Of learned men this is the art" (2.1.2:394)

Great... it should look something like

DoCmd.OpenReport "Query1", acViewPreview, ,"[Issue to whom] = '" & Me.EmployeeName & "'"


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Yes greg i got it ,

 simillarlly i got the report , But while generating the report the data in the report repeating 20-30 time , I don't know what to do
 Pls help me in this issue

P.A.P.Raguv

Is it possible that your query is not set to give you distinct records and is repeating due to your criteria? If your query has joined tables, you may have to double-click anywhere in the gray area (not on a table) and choose "Unique Record" or "Unique Value" from that dialog box.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

 Hi gerg,

  I got the answer thanks again for the reply and i happy to see your respones and solving the issue to develope the beginers like me.
  thanks from my deep heart
bye,

P.A.P.Raguv