Set up a default in Combo Box to show when opening a form

I have a combo box which uses a table with No and Yes. I want the No to be
the default whenever I open the form. I have tried several default values
suggested in microsoft but none have worked.
--
Julia

Yes/No fields in Access are designated -1 for Yes and ) for No. So your combo
format needs to be set to number and then in your control source put
=IIF([yourfieldname]=-1,"Yes","No")
--
Milton Purdy
ACCESS
State of Arkansas


"JuliaO" wrote:

I have a combo box which uses a table with No and Yes. I want the No to be
the default whenever I open the form. I have tried several default values
suggested in microsoft but none have worked.
--
Julia

Julia

A common way to handle Yes/No is with a checkbox, rather than a combobox.
Is there a reason your application needs to use a combobox?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"JuliaO" wrote in message
...
I have a combo box which uses a table with No and Yes. I want the No to be
the default whenever I open the form. I have tried several default values
suggested in microsoft but none have worked.
--
Julia