Combo box value list - "*"

G

Guest

I have combo box name cboLead-

Row Source Type: Value list
Row Source: "Yes";-1;"No";0;"Yes\No";"*"

if you choose Yes its working and if you choose No its working
but if you choose Both = Yes\No its have an error said

The expression typed incorrectly or too complex to evaluated etc.....


Its make me wonder cause I have this value list in other form to filter
report and its working fine its exactly the same just only different report.
Is there any way to I can use to work my filter.


Help appreciated a lot....Thank you in advance.....
 
V

Van T. Dinh

Is this ComboBox bound to a Boolean Field? If it is, a Boolean Field can
only have -1 (True) or 0 (False).

What do you do with the value selected by the use? ComboBox_AfterUpdate
Event?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box default value 1
Controlling a list box population based on combo boxes 1
Combo Box not refreshing after changing Row Source in code 0
stop automatic data filling in combo boxes 5
can't select from combo box 4
Choose a value from a combo box based on a text box 0
combo box selection to auto fill a second combo box (or field) 1
Unable to select a value from combo box 3

Top