Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I make a button in access2007 that filters a report based off of a listbox?
In access 2007 i'm trying to make a button that opens a filtered report based off a single selection in a listbox.
For example, my listbox contains 8 selections. Based off the selection in the listbox, the button will open a report that is filtered by the listbox selection. So if I pick "For Signature" in the listbox, the button will open the report filtered by "For Signature"
I've been scratching my head on this one for awhile. Any help would be great!
Right now I have a button that is supposed to run the filtered report based on the selection in the combo box. I have:
DoCmd.OpenReport "Decorations Pending", acViewPreview, , "Status = 'get items in list99"
I don't know how to tell access to pull from what the user picked in the combo box. Only 1 selection can be made and there isn't a blank spot, so I don't think I need the If/Else.
1 Answer
- ray_diatorLv 79 years agoFavorite Answer
The old way was to create a form that contains macros and when you click a menu item it runs a query or report.