Combo Box query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with 7 different check boxes, unbound. Each one of these is
given a tag value. Now I also have a combo box unbound. I am trying to run a
select query where if the check box is true then add it to the combo box
query, if not then don't. I am sure this possible, but I am unsure on how to
do this. I tried if the checkbox = true then add, but that didn't work as
well. Here is my test for just one of them. Any suggestions?


SELECT tblCategory.CATID, tblCategory.Category
FROM tblCategory
WHERE
((tblCategory.CATID)=IIf([Forms]![frmSetupForCRTPPractical]![RW_D]=True,"1"))
ORDER BY tblCategory.CATID;
 
If the combo box is unbound, adding some calculated/derived value based on a
checkbox won't update any field in any table.

You've described "how" you are trying to do something. I'm not clear on the
"why" or "what". Perhaps there's another way to accomplish what you are
trying to achieve --
 
Thanks for the reply.
I have a table called tblCategory each one of these checkboxes is tagged to
one of the items in the table. The user can select any, mutiple check boxes.
From their selection I am trying to use a query with a combo box. Once this
is accomplished then another combo box is used to get the attributes of this
1st combo box. Then I have another combo box that shows the categories left
over from the 1st combo box and another to show its attributes. I have
several steps after this but if I can get the first one down it should be
easier.

I don't want the value to be displayed only the actual category.

Once all the boxes are filled in then I will run some code to create a
record with all fileds on the form.
 
Back
Top