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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using A Listbox As Criteria For A Query

Status
Not open for further replies.
Lee24

Lee24

Programmer
Apr 11, 2001
103
GB
Want to display a list box for some reports within. Let the user click on one or several have a button that will link directly to the appropraite reports!

All comments welcome!

 
Sort by date Sort by votes
If the report name is the same as the selection within the listbox, then

DoCmd.OpenReport ListboxName.SelText 'No quotes

If the selections are different from the report names, then use "case" statements and surround the report names with quotes.

mac318
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
13
Views
425
strongm
strongm
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
3K
dhookom
dhookom
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
230
mikrom
mikrom
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
885
serino
serino
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top