Frothingslosh, thank you so much for your time explaining everything.
I was concerned after my last post required approval, for said reason.
Regardless I found your knowledge, and direction extremely helpful.
Please note your time is greatly appreciated.
I will surely return to this forum...
Finally was able to identify the line of code I wrote to Ignore the 3061 Runtime Error was actually skipping over the Like "qryQC_*" line.
This was resolved by utilizing proper error handling
using "On Error Resume Next"
Again, thank you all so much.
This was an excellent learning experience...
Please excuse my ignorance, [Utility Functions] is something I just googled to make the qry's populate in the combo box. Which does work great. Only problem it pulls all qry's. The issue I'm having is the "Like "qryQC_*" not having any impact on the results that populate within the combo box...
Thank you both again for the pointers.
I have tried both suggestions, and still no change in the result.
Here's the screen shot in a zip..
Everything works without errors.
It's just providing me with all the qry results.
I'm only wanting to see those that match Like "qryQC_*" in the combo box.
Now that I'm able to place the qry results in the combo box..
How can I make it so the only choices to choose from are queries that begin with "qryQC_" ?
I've tried this, but it doesn't work unfortunately..
If qdf.Name Like "qryQC_*" Then
I must be missing something.
Screen Shot...
Thank you for your prompt responses.
After spending a few hours with trial and error I was able to resolve it myself.
The objective was to pull all results from all queries named like "qryQC_"
Then place them into a combo box for selection.
Not that it may be useful to anyone,
but the final...
Hello,
I am new here, and new to using VBA in Access.
I've been presented with an existing code below.
The objective is to have Access Pull Query Results in a Drop down.
The code errors out on the line in red.
Can someone point me into the right direction to make this work?
Any assistance...