How to give the parameter value Yes or No?

[JithuAccess]

Hello,

I was trying to create a query based on the parameters a user enter. I have created a user form and when user select "Yes" I want to display all the records which are completed. The field Completed is a Check Box.

In the Query design view when I enter Yes (without double quotes) query returns me all the completed records but when I am getting error when I try to give this code in the criteria

[Forms]![frmQueryParametersInputForm]![Combo29]

This is the error I am getting.

Could you please let me know how to fix this?

Thanks

 

[theDBguy]

Make sure the value in the combobox is either 0 or -1. You can use a two-column row source for that.

 

[June7]

Is Combo29 UNBOUND? What is its RowSource?

 

[JithuAccess]

Is Combo29 UNBOUND? What is its RowSource?

Yes it is Unbound and the RowSource is Yes;No

 

[June7]

AS Guy suggested, set up combobox with 2 columns.
-1;Yes;0;No

ColumnCount: 2
ColumnWidths: 0";0.25"

Advise give controls more meaningful names.

 

[JithuAccess]

Make sure the value in the combobox is either 0 or -1. You can use a two-column row source for that.

AS Guy suggested, set up combobox with 2 columns.
-1;Yes;0;No

ColumnCount: 2
ColumnWidths: 0";0.25"

Advise give controls more meaningful names.

Thank you so much

It worked perfectly

 

[JithuAccess]

Make sure the value in the combobox is either 0 or -1. You can use a two-column row source for that.

Thank you so much. It worked

 

[theDBguy]

Thank you so much. It worked

Glad we could assist. Good luck with your project.