Y/N Drop Down

[Mojo1]

I would like to put a yes/no drop down on a form. Where do you find this in the controls? When you put it on the form how does the value of Yes or the value of No go to the table?

 

[Joe4]

Actually, the best place to set it up is right in the table itself, then it should carry right on through to your report.

As you create/edit the variable in your table, select "Yes/No" as your Data Type instead of "Text". Then, go to the "Lookup" tab of the field in the table and change Display Control to "Combo Box", change Row Source Type to "Value List", and then enter "Yes;No" (without the quotes) in Row Source. The field is now a Yes/No drop down box.

You may need to delete the field from your report and then add it back again to get these field changes to take place on your report.

 

[Mojo1]

Combo Box

I put a combo box control on the form made it unbound, then I went into it's properties and made the changes like you said. I believe your process is easier. My question is that if I go and make the changes you suggest and the current value in the field in the table is No and I make a change so the defalt vale is Yes how do I prevent the new default value from being put into the table for the first record.. I guess I could write down all the values of the fields I am worried about and put in the combo boxes and them change them back to their original values if they change??

Any suggestions?

 

[Joe4]

You kind of lost me...

The changes I recommended are NOT to be done on the Form but on the field right in the Table itself. You should be able to keep the same default values. All you are doing is changing the structure of the underlying field in the Table.

After you make those changes, then you can go to the form and delete your old unbound control and replace it with the actual field itself from the Field list. Since we changed the structure of the field in the Table, the field should automatically show up as a drop down box.

 

[Mojo1]

I totally understand what you did.

I just said there was another way to do what you did as well.