can't select from combo box

[Gitche Gumee]

I have a combo box on a form that won't allow me to select a value. The row
source is a value list. The combo box is bound to a field in the form's
record source (a query). I can select a value from the value list if the
combo box already shows a value. But if there is no current value in the
field, I can't select one.

I have other combo boxes on the same form that work just fine. And this one
used to work fine too.

Any ideas?

 

[Jeanette Cunningham]

Gitchee,
create a new combo box to replace the one that's not working.
If the new one works as expected, just delete the other one.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Gitche Gumee]

I tried that with no luck. I tried changing it from a combo to a list box and
to a text box. I can add other fields from the same query which belong in the
same table and they work. I tried compact and repair.

But here's something else I just noticed. I can add fields to the form by
using the combo box tool or the text box tool etc and then setting the
control source in the properties window. But I cannot drag and drop any
fields from that query onto my form in design view.

 

[Gitche Gumee]

Well, I know what the problem is but not how to solve it. The combo box is
bound to a field in a related table that needs to write a new record if there
is no existing info. I can do that with a subform. Is there another way?

 

[Jeanette Cunningham]

You can use the Not In List event, or you can put a button or a hyperlink
next to the combo to open the form to add a new record to this table.
The form to add the new record would be opened using the acDialog argument -
the add new form would open on top of the other forms and users would need
to close this form before they could return to the underlying form.



Jeanette Cunningham -- Melbourne Victoria Australia