Open report

[Guest]

Hi..

how can i open a report from a buttom on my form in the way that i use my combo box [Tips Nummer] as a parameter (the report is based on a query where "Tips nummer" must be my input parameter) .

Thanks for any help!!

Erik

 

[Marshall Barton]

how can i open a report from a buttom on my form in the way that i use my combo box [Tips Nummer] as a parameter (the report is based on a query where "Tips nummer" must be my input parameter) .

Use the command button wizard to create the code to preview
the report. Then open the form's module and modify the code
to look like:

Dim stDoc As String
Dim stWhere As String

stDoc = "nameofreport"
stWhere = "[Tips Nummer] = " & thecombobox
DoCmd.OpenForm stDoc,acViewPreview, , stWhere