W
will eichert
Greetings. I have a problem with a combo box incorrectly displaying
blank items when returning to a form from a modal form. It's fine when
the main form first comes up, but gets messed up when the main form is
reactivated following opening and closing a modal form. Strangely,
this was not a problem until I started using my Access 2000 db in
Access 2003 (as an Access 2000 db). Details follow...
I have an unbound combo box on my main form which allows selection of
a user. Its rowsource is a query. When a user is selected, a subform
displays a summary record for each order associated with this user.
Pressing a button in the subform header brings up a modal form
containing the details of the selected user order. This form is opened
by VB code as follows:
DoCmd.OpenForm "orderdetail", , , , , , OrderID
After the orderdetail form is closed by the user, the combo box on the
main form contains a bunch of blank items, nothing else. It looks like
there are the correct number of items, but they're all blank, and
selecting them does nothing. In the main form's Activate event
handler, I have a Requery for the combo box control.
Also, the behavior is somewhat erratic. The usual behavior is that the
1st time I go to the order detail form, then close it, the main form
combo box has the correct items. Any subsequent openings and closings
of the order detail form results in the combo box with blank items.
Sometimes, it will be ok for 2 or 3 times of invoking the detail form;
as I said it's erratic. Once it's messed up it stays messed up until I
close the main form and re-open it.
I've spent a ridiculous amount of time trying to resolve this, and
still have the problem. It's probably something obvious, but it won't
be obvious to me until I know it ;-) Any ideas?
Thanks,
Will Eichert
blank items when returning to a form from a modal form. It's fine when
the main form first comes up, but gets messed up when the main form is
reactivated following opening and closing a modal form. Strangely,
this was not a problem until I started using my Access 2000 db in
Access 2003 (as an Access 2000 db). Details follow...
I have an unbound combo box on my main form which allows selection of
a user. Its rowsource is a query. When a user is selected, a subform
displays a summary record for each order associated with this user.
Pressing a button in the subform header brings up a modal form
containing the details of the selected user order. This form is opened
by VB code as follows:
DoCmd.OpenForm "orderdetail", , , , , , OrderID
After the orderdetail form is closed by the user, the combo box on the
main form contains a bunch of blank items, nothing else. It looks like
there are the correct number of items, but they're all blank, and
selecting them does nothing. In the main form's Activate event
handler, I have a Requery for the combo box control.
Also, the behavior is somewhat erratic. The usual behavior is that the
1st time I go to the order detail form, then close it, the main form
combo box has the correct items. Any subsequent openings and closings
of the order detail form results in the combo box with blank items.
Sometimes, it will be ok for 2 or 3 times of invoking the detail form;
as I said it's erratic. Once it's messed up it stays messed up until I
close the main form and re-open it.
I've spent a ridiculous amount of time trying to resolve this, and
still have the problem. It's probably something obvious, but it won't
be obvious to me until I know it ;-) Any ideas?
Thanks,
Will Eichert