Open report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Erik said:
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) .
Click to expand...


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
 
Back
Top