Strange Combo Box Behavior

[Wadero]

I've never seen this before.

I have a form bound to a non-updateable query. There is an unbound combo box in the form footer.

When the form contains no records, the combo box display goes blank after you make a selection. I checked the After Update event of the combo box and the value selected is still intact but it will not display it in the actual box on the form. I've tried Me.Refresh, Me.Requery, nothing works.

If the form contains records it works just fine but often times this form may not show any records when it is first open.

Check out the attached sample DB. Can anyone explain this one?

Thanks.

 

[MStef]

As I can see your combo work well,
I don't know what's the problem.

 

[Wadero]

You're saying when you made the selection in the combo box, the box did not show blank?

I just tried this sample on another machine with Access 2000 and it still acts up. I'm wondering if this is a bug in my version of Access and it needs further updates downloaded. I thought I had all available updates installed though.

 

[jrjr]

It doesnt work right for me either

 

[lgw002]

Works ok for me. Shows dropdown and then populates the two date boxes ok every time, however shows error when promotion button clicked ( presume this is a seperate problem or not coded fully yet ?)

Have you tried another simplified form without fields in the the headers and footers and see if you still get a blank combo ? I'd try it myself but I'm not getting errors