Yes No Combo Boxes Queries Filtering as 0 and 1 Instead....work ar

Hi guys,

I have a form with 5 combo boxes, the results of which are passed to a query
to display a list of orders. One of the combo boxes is called OrderComplete
with a value or either Yes or No obviously determining whether the query
shows incomplete orders or not.

However, to get the query to work, the OrderComplete Combo box should have
the options 0 and 1 instead of yes and no, but this is not ideal as the
database users won't know that 0=No and 1=Yes, is there a way around this?

Thanks in advance.

Ricahrd,

Yes, there is, and it's pretty easy. Whjen you start to make a combo on
a form the wizrd kicks in, and if you select to type in the values it
allows you to enter two columns like:

0 No
1 Yes

then is asks you whether you want to show both columns, or hide the
first; opt for the latter, so the user sees Yes/No, but the numeric
values are returned to the query.

That said, I would have taken another approach: for a yes/no set of
possible answers, I would use check boxes; those return True/False (or
-1, 0 respectively) to the query, and the user only sees check/no check,
and can change the status in one move (vs two for a combo), plus an
array of chekcs/no checks is more readable than an array of Yes and No 's.

HTH,
Nikos

Richard Horne wrote:
Hi guys,

I have a form with 5 combo boxes, the results of which are passed to a query
to display a list of orders. One of the combo boxes is called OrderComplete
with a value or either Yes or No obviously determining whether the query
shows incomplete orders or not.

However, to get the query to work, the OrderComplete Combo box should have
the options 0 and 1 instead of yes and no, but this is not ideal as the
database users won't know that 0=No and 1=Yes, is there a way around this?

Thanks in advance.

That worked a treat Nikos, thank you very much my friend.

"Nikos Yannacopoulos" wrote:

Ricahrd,

Yes, there is, and it's pretty easy. Whjen you start to make a combo on
a form the wizrd kicks in, and if you select to type in the values it
allows you to enter two columns like:

0 No
1 Yes

then is asks you whether you want to show both columns, or hide the
first; opt for the latter, so the user sees Yes/No, but the numeric
values are returned to the query.

That said, I would have taken another approach: for a yes/no set of
possible answers, I would use check boxes; those return True/False (or
-1, 0 respectively) to the query, and the user only sees check/no check,
and can change the status in one move (vs two for a combo), plus an
array of chekcs/no checks is more readable than an array of Yes and No 's.

HTH,
Nikos

Richard Horne wrote:
Hi guys,

I have a form with 5 combo boxes, the results of which are passed to a query
to display a list of orders. One of the combo boxes is called OrderComplete
with a value or either Yes or No obviously determining whether the query
shows incomplete orders or not.

However, to get the query to work, the OrderComplete Combo box should have
the options 0 and 1 instead of yes and no, but this is not ideal as the
database users won't know that 0=No and 1=Yes, is there a way around this?

Thanks in advance.

Welcome!

Richard Horne wrote:
That worked a treat Nikos, thank you very much my friend.

"Nikos Yannacopoulos" wrote:


Ricahrd,

Yes, there is, and it's pretty easy. Whjen you start to make a combo on
a form the wizrd kicks in, and if you select to type in the values it
allows you to enter two columns like:

0 No
1 Yes

then is asks you whether you want to show both columns, or hide the
first; opt for the latter, so the user sees Yes/No, but the numeric
values are returned to the query.

That said, I would have taken another approach: for a yes/no set of
possible answers, I would use check boxes; those return True/False (or
-1, 0 respectively) to the query, and the user only sees check/no check,
and can change the status in one move (vs two for a combo), plus an
array of chekcs/no checks is more readable than an array of Yes and No 's.

HTH,
Nikos

Richard Horne wrote:

Hi guys,

I have a form with 5 combo boxes, the results of which are passed to a query
to display a list of orders. One of the combo boxes is called OrderComplete
with a value or either Yes or No obviously determining whether the query
shows incomplete orders or not.

However, to get the query to work, the OrderComplete Combo box should have
the options 0 and 1 instead of yes and no, but this is not ideal as the
database users won't know that 0=No and 1=Yes, is there a way around this?

Thanks in advance.