Query can not be used as a row source

[yrstruly]

I would like to have a drop down buttin yes/no. I tried with SQL, im getting he above error.

[June7]

Provide the query SQL.

But if you just want Yes or No options, don't need SQL for that. Use value list.

[yrstruly]

[yrstruly]

I can see the code in the drop down now, its only suppose to show yes/no

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

[yrstruly]

[June7]

Property settings:

Row Source: Yes;No

Row Source Type: Value List

Format: Yes/No

[yrstruly]

[yrstruly]

I get this output.

[June7]

You aren't using the settings I showed. Review my last post.

[yrstruly]

I did...See pics

[madpiet]

Not sure about your last question, but the other one with the Yes/No list you made, you'd set the column widths to 0;0.5 or something - it will hide the numeric column and show only the "Yes"/"No" values.

[yrstruly]

0;0.5, give no output or i cant see it.

[madpiet]

post your database... or at least the front end.
The fumigation status one...
Column Count: 2
Width: 0;1 (For example)... the first one should be zero.

then the value in the first column (column(0)) will be written to the table, and the rest will just be displayed. (well if the width isn't 0 for that column)

[yrstruly]

I cant post pictures, this system is reall not uer friendly. How do i share a db without exposing data?

[madpiet]

These are the important properties of the combobox that you're having fun with:
Column Count: 2
Column Widths: 0;1
List Width: 1
Width: 1

(Notice that the total of the column widths is 1, and that matches the List Width property setting)