Combo boxes with queries

[Maxine via AccessMonster.com]

Hi guys,

I was recommended this site as the best place to find solutions for those
problems that take ppl like me days to solve but you guys just seconds!!

I am really a beginner, simple advive would be great, the code that I have
been using below, I found on this site.!!

I have an input page that contains four combo boxes
one of these looks like: (though the rest do the same thing)
Category A)
Issue 1
Issue 2
Issue 3

I have also set up lots of queries so that i can isloate each of the issues.
So that if i only want issue one then i get all those records.

What i cant seem to figure out is how i can have combo boxes identical to
that on the input page, that look up the queries. so that when i click on an
issue it will only look up the relavent cases.

I have tried the following code in a blank combo box
SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like
"~*") And ((MSysObjects.Type)=5));

and then put a button beside it with the code:
Private Sub Command4_Click()
If IsNull(Me.Combo0) Then
MsgBox "Please select a query to view!"
Exit Sub
End If
DoCmd.OpenForm Me.Combo0
End Sub


The problem with this is that it puts all the queries into one combo box, but
i want to be able to separte them out under my categories. I need to be able
to select which queries go into each of my four combo boxes
If there is a way to do this by modifiying the existing code, id love to hear
about it, or if there is a simpler way of doin it id really love to know....
Thanks guys....

 

[Jeff Boyce]

Maxine

You've described a lot of the "how" (how you are trying to do something).

What I can't really visualize is the "what". You are trying to do
something the way you've learned so far, but I don't have very good idea
what business need you are trying to solve.

If you were to describe to an 80 year old grandmother what you hope to
accomplish, what would you say? I'll bet you wouldn't talk about computers
or Access, but describe what you're doing in "real world" terms.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/