Combo Box - Can't select Until I go into Design & back out

[tallbarb]

Very odd - when open a form and try to UPDATE the value in a combo box control, it won't allow it. However, if I go into design view for the form and then back into form view, it will. Any idea what the heck is going on here???

 

[TheAceMan1]

How are tallbarb . . . .

Just how are you trying to update the Combobox?

Post the code if you can . . . .

TheAceMan

 

[tallbarb]

It's a combo box created with a value list in the table - nothing out of the ordinary - I've done it a million times without a problem. I've never seen anything like this before WIERD.

 

[TheAceMan1]

tallbarb . . . . .

I understand what you've posted so far. No problemo!

I can't help you unless I konw how your trying to Update the combobox! I could be wrong . . . . but I don't think anyone else could either . . .

Please! . . . . . . . specify! . . . .

See Ya! . . . . . .

 

[tallbarb]

OK - this is one of those times when, red-faced, I have to admit to being an idiot. For crying out loud, where is my brain - and I feel guilty that anyone took time to read and respond to this message. Here's what the problem was (and please, don't give me too much grief - I've already done that to myself!!!!). The form was opened by a macro in read-only mode. OK - go ahead and laugh - I can take it. DUHHHHHHHH

 

[TheAceMan1]

Wow! . . . OK tallbarb . . . .

First, anyone who comes to Tek-Tips and asks a question, [purple]is showing the greatest intelligence known to man![/purple]

I've had it in my mind, since reading your post origination, to advise you to [blue]ReQuery[/blue] the combobox. But, if your opening it in [blue]Read Only Mode[/blue], this is the reason your getting the results you've explained. You see . . . . . anytime you open a form (Read Only Or Not) Combo & List boxes are [blue]ReQuired![/blue] Apparently after the form is open your trying to update the combobox with something else. Apparently you already know, this cannot be done in [blue]Read Only Mode[/blue], and not only that, there's no way you cold have done this hundreds of times in this mode.

So . . . . . wether its in Read Only Mode or not . . . . you still hav'nt told me how you trying to update the combobox! Is it something [blue]proprietary[/blue] or what? I still need to know . . . . I can still help you, [blue]as many others could here at Tek-Tips . . . .[/blue] [purple]but your gonna have to give up the ghost! . . . . . .[/purple]

See Ya! . . . . . .

 

[tallbarb]

The combo box is bound to a field - it gets its list from a value list set in its properties at the table level. Did I mention NONE of the form could be updated - I should have. And THAT should have clued me in as to why......

Anyway - the combo box's contents are being updated the usual way - by a person who opens the form by clicking on the Command button of a menu which runs the macro that opens the form - and then clicks on the drop-down arrow to choose from the list. But all the controls are locked, not just the combo control. I'm not sure what else I can tell you....

Again...duhhh duhhh duhhh

 

[TheAceMan1]

OK tallbarb . . . .

I was under the impression you were using code somewhere.
I sure you know what ya have ta do . . . .

See Ya! . . . . . .