Help on Combo Box on new form

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

Guest

Hi,

I have created a pop up box which has a combo box within. I want to be able
to choose a name in the list and it then goe through to another report and
choose the name and show me all the results, how can I do this
 
If I understand you correctly, you wish to open a report, filtering its
records by your combo box selection. Is this correct?

If so, base your report on a query, and set the selection criteria for the
field matching your combo box to:

=Forms!YourFormName!YourComboBoxName

Then to open the report in preview mode, the required code is:

Dim stDocName As String

stDocName = "YourReportName"
DoCmd.OpenReport stDocName, acPreview

Hope that helps.
Sprinks
 
Back
Top