Combobox has a value in it when form is opened 1

[projecttoday]

I have an unbound combobox which has a value in it when the form is opened. It shows the same value every time. I'd like to get rid of this and just have a blank combobox like I have on several other forms when they are opened. Otherwise the combobox seems to be working fine. What causes a combobx to show the same value every time the form is opened? This value is not the first value in the list. I don't know why it appears.

 

[missinglinq]

Either the combobox is bound to a field in the underlying table or you have assigned a Default Setting to it, possible when you created the combobox. When using the Wizard to create the cbo, there's a window that asks if you want a Default Value set; this is set to one of the values and you may have breezed by it without unchecking the item Access chose. thus leaving it with a Default. Or, less likely if you developed the db, the Default could be set in code, probably either in the Form_Load or Form_Current events.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[projecttoday]

A default value had somehow gotten in there. Thanks.

 

[TheAceMan1]

Howdy missinglinq! . . .

You've been doing very well!

Keep up the good work! ... a deserved pinky for you ... particularly if [blue]projecttoday[/blue] wont!

Its amazing isn't it! They never really learn how to thank us!

Either way ... you've certainly come a long way!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[missinglinq]

We're like Rodney Dangerfield, Aceman1, can't get no respect!

Thanks for the kind words!

Linq


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!