QBF Form - Combo/Check Box Help

[nosaj_ccfc]

Hello,

firstly apologies if this is being posted in the wrong section. I thought this one would be most appropriate.

Let me try to explain my problem as it is confusing to me. I have been designing an Access database for my company which keeps track of orders. Users enter the data through a form and the data is stored to the table. I have created a QBF (Query by Form) to enable administrators to do a custom search. The fileds are created, checked, invoice number and date. All of this is working fine with no problem.

I also have a checkbox on my data entry form, which is ticked depending whether the paper invoice has been received or not. When I try and add this to my QBF, I use a combo box for the admin to select the option, or leave blank if required. However I can only get the combo box to work if the values "-1" or "0" are used. I realise these are Access values for whether a checkbox is true or false (i think), but I was just wondering is there any way I can subsitute them for English values (True/False, Yes/No etc.) instead of just integers. This would not be a problem if I was simply using the database myself, however it will be used by other people, and the English words would be better to understand.

apologies for the length of my question, I just wanted to give as much information as I could.

Many Thanks for any help,

nosaj

 

[DCrake]

Combo Box Properties

Rowsourcetype = Value List
Rowsource "Yes";-1,"No",0
ColumnCount = 2
ColumnWidths = 1cm,0cm
Bound Column = 2

Make the following setting for your combo box. It will show Yes and No for the options but store -1 or 0 to the table.

CodeMaster:

 

[nosaj_ccfc]

DCrake, thank you for that, it is almost exactly what I need. I was trying something similiar earlier and just did not think abou tthe column settings.

Final questions on this, is there a way I can have a 'blank' option in my combo box? and still use the above? So that if the user wants to conduct a different search not using the previous values, the combo box can be set back to ' '. I am thinking something like "";NULL;"Yes";-1,"No",0 if that makes any sense


Hope I come across clear

Thanks so much for your help

nosaj

 

[nosaj_ccfc]

I think I may have found a solution to the 'blank' problem, instead of using NULL as above I use the following value list

""; ;"Yes";-1;"No";0

with no integer value assigned to the blank option. This seems to work so far, but if anyone feels there is a more optimal or efficiant way to do this, please let me know

nosaj