Disembodied dropdown list of ComboBox

[John S. Ford, MD]

This has got me completely baffled. I have a program I coded in Access 97
that seemed to have been working perfectly. But today it began behaving
strangely.

I have a command button on the footer of a subform that can delete a record
on that subform. If the record is the last record in the datasource of the
subform, the form goes completely gray (including the controls) except for
the buttons of the subform footer because the subform's AllowAdditions
property is set to False.

This all works as expected. My problem is that the dropdown list of one of
the subform's ComboBox appears out of nowhere out in space not even on the
main form. This didn't used to happen.

Does anyone have any ideas why this happens now? It doesn't look like a
coding error the list appears completely disembodied from the main form. I
reinstalled Office 97 and it still behaves like this.

John

 

[Dan Artuso]

Hi,
I've never seen that particular thing but, have you tried a
yourForm.Repaint

in the code somewhere to repaint the form?

 

[Martin Wilson]

That's a good idea. Requery may help as well.

Hi,
I've never seen that particular thing but, have you tried a
yourForm.Repaint

in the code somewhere to repaint the form?

 

[John S. Ford, MD]

Can anyone think of any reasons why I'd have to do a requery or a form paint
to prevent this from happening? I haven't tried it yet but I'm trying to
treat the underlying disease and not the symptom!

John

 

[david epsom dot com dot au]

I don't know why this should suddenly happen, but note that there
has always (???) been some odd behaviour, particularly with
combo boxes, associated with forms with 'missing' detail sections.
I think that combo boxes may just be liable to confusion in this
situation.

But since it only suddenly started, I would recommend rebuilding the
form.

(david)