Query Criteria

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

Guest

I am running a query through a form by using [Forms]![myform]![cboname]
I used this for when I was using combo boxes, but now I am trying to do it
with check boxes but it isn't working. Does cbo stand for something
specifically related to combo boxes? Is there something like cbo for check
boxes? Or will check boxes not work? Any help would be great! Please let me
know if you need clarification

Angela
 
Can you post the SQL you using with the filter of the check box?

After update event of the check box did you run the code
me.SubFormName.requery
 
I'm not entirely sure what you are trying to do, but:
1. 'cbo' has nothing to do with combo boxes. This is a convention that some
people use to name combo boxes.
2. If the name of your checkbox is also 'cboname', this should work just as
well, depending on what you're trying to accomplish.

Combo Boxes and Checkboxes serve different purposes. Maybe you should tell
us what you're trying to do.
 
Not sure what you are doing in your query but a checkbox contains data as
zero or minus one.
 
Actually, that helped. The check box wasn't working and I thought it had
something to do with "cbo"
Well, I wanted to have a parameters box for my query with a combo box, but
then I found out that the only way to do this is to have a form with a drop
drop that kind of links into the query by using [Form]![MyForm]![cboname] in
the criteria box. I then realized that if I want to do this I also need to
have my check boxes for project types in this query-linked form. I acutally
got the check box to work in my fake testing database, but for some reason it
isn't in my real one. I am sure this will all short out though. Thanks all
for your help


Chaim said:
I'm not entirely sure what you are trying to do, but:
1. 'cbo' has nothing to do with combo boxes. This is a convention that some
people use to name combo boxes.
2. If the name of your checkbox is also 'cboname', this should work just as
well, depending on what you're trying to accomplish.

Combo Boxes and Checkboxes serve different purposes. Maybe you should tell
us what you're trying to do.

--
Chaim


Angela said:
I am running a query through a form by using [Forms]![myform]![cboname]
I used this for when I was using combo boxes, but now I am trying to do it
with check boxes but it isn't working. Does cbo stand for something
specifically related to combo boxes? Is there something like cbo for check
boxes? Or will check boxes not work? Any help would be great! Please let me
know if you need clarification

Angela
Click to expand...
Click to expand...
 
Back
Top