Combo Box Not Allowing Selecting of Value

[Robert W]

I have a combo box on a form and it is based off of a
query that lists the tables and queries in the database.
The list lets you choose what database object you want to
export, but when I open the form, it does not allow me to
change the value in the combo box. I'm using Win and
Office 2000.

Thanks for your help.

Robert W

 

[John Spencer (MVP)]

Did you bind the combobox to a field? That is set the control source to a
fieldname. If you are using the combobox to get information for use elsewhere
you don't want it to be bound.

 

[Robert W]

The combo box's control source is the query that finds all
database objects.

How do you know if it is bound?

I also have it on a tab control field with 5 tabs on it.
Does that make any difference?

Robert