Access Search Template - How To Create Advanced Search Forms, Filters, Parameters, and Dynamic Queries in Microsoft Access


	Back to Search Seminar Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Search Template

Michael Albert

4 years ago

I would like to have a combo box that contains the names of certain reports available for preview/print and to execute that report by clicking the report listed in the box. Do you have a lesson that covers this? If so, what lesson or course?
Thanks a bunch.

Adam Schwanz @Reply

4 years ago

If you have a combo box with lets say 3 values for this example, say Customer, Order, and Contact and you have a report for each of those, there are a few ways you could do it, you could just do an on-change or after/update event on the combo-box like below

If ComboBox = "Customer" Then

'open the customer report

ElseIf ComboBox = "Order" Then

'open the order report

ElseIf ComboBox = "Contact" Then

'open the contact report

End If

	Kevin Robertson @Reply 4 years ago
Report Listbox

	Michael Albert OP @Reply 4 years ago
Thanks, I'll give it a go.

	Adam Schwanz @Reply 4 years ago
Of course Rick has a video for every little specific issue ;). Check out that video Michael.

	Richard Rost @Reply 4 years ago
That's my goal... so that no matter what issue someone searches for on Google, one of my videos shows up. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Search Seminar Lessons.

Next Unseen

New Feature: Comment Live View