Default Value for combo Box

[TimTDP]

I have a table consisting of the following fields:
CompanyId - Field type = Auto Number
Company - Field type = Text
Active - Field type = Yes/No

On a form I have a combo box, which includes all the above fields. The first column is field CompanyId and this the combo box's bound column.

When ever the form opens I want the combo box to display the name of the company where Active = Yes.

How do I do this?

 

[antonyx]

in the row source of your combo, i think you will have to put something like

SELECT tablename.CompanyID, tablename.Company, tablename.Active WHERE tablename.Active=True

 

[TimTDP]

But then how do I select other records in the combo box?

 

[antonyx]

well u said that when your form opens, you only want to display companies where active is yes..

you will see all the companies that are active..

where else would you want to see the other records??

 

[Tigerlili3]

antonyx and I are both trying to understand what you need to accomplish. Will there only be one company that will have active as 'yes' or will there be more than one?

 

[TimTDP]

More than one

 

[stix4t2]

Hello Tim,

Just a couple of questions to better answer your question. Is the combo box bound, tied to a field, or unbound. When the value is put in the combo box, do you want the form to move to that record?