Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo on a report

Status
Not open for further replies.
SheepDog

SheepDog

Programmer
Feb 4, 2003
232
US
I would like to put a combo box on a report based off a query so when I made a selection from the combo it would display that info based upon the criteria selected.
I have never done this with a report and would like some help/suggestions.
 
Sort by date Sort by votes
You should put the combo box on a form. Then you can put a button on the form to launch the report. Use something like this for the OnClick event of the button:

DoCmd.OpenReport "YourReportName", acViewPreview, , "YourField = '" & cboYourComboBoxValue & "'"

-Gary
 
Upvote 0 Downvote
Can I put a combo box in the report header so that it will display the data in the detail of the report for records based upon the selection in the combo box?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
528
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
591
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
764
caykamanj1966
caykamanj1966
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
368
sxschech
sxschech
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
494
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top