Adding Combo Boxes to a Report????

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

Guest

Hi,

I want to add a combo box to a report. I have added a combo box to my
report, which the control source comes from a table. When I then run the
report the combo box doesn't appear??? Why?

What I want to do is when the report runs, I then select, from the combo
box, someone's name, and it then shows the information for that peron in the
report. Where at the moment it produces 100's of separate reports.

I hope this is possible, I have tried looking in my access books but it
doesn't seem to cover this off. Maybe because it can't be done?

Thanks

Paul
 
A report is not interactive. You can't add a combo-box to a 'report' and
then make a selection. A report is way of VIEWING data. Forms are
interactive.

You would need to make the selection in a form that then produces the
desired report.
 
Note: I have done this to produce a report from my Employee database. Here
is the code tied to the print button on my employee maintenance form:

Private Sub Print_Button_Click()

If (IsNull([UserID])) Then

' Verify the key field (UserID) has a selection

Exit Sub

End If

DoCmd.OpenReport "rptEmployeeData", acViewNormal, "",
"[UserID]=Forms![frmEmpMaint]![UserID]"

End Sub









Rick
 
Back
Top