B
Brett Wilson
I have a subform on a main form that contains a combo box. The combo box
recordsource is set dependent on the current record of the main form in the
"On Enter" event of the combo box. The combo box recordsource is set to a
dynamically constructed SQL query to the MSDE backend. Everything works
sometimes, but other times the combo box only gets populated with a subset of
the desired records. This subset is sometimes, but not always, the same.
I've got the same problem in another database that is all MSAccess (no MSDE
backend). For some reason the combo box does not fill up completely. This
occurs with other users also, not just me.
Windows 2000 Pro with MSAccess 2000, MSDE 2000 with all updates to Windows,
Office, MSDE, MDAC2.8.
recordsource is set dependent on the current record of the main form in the
"On Enter" event of the combo box. The combo box recordsource is set to a
dynamically constructed SQL query to the MSDE backend. Everything works
sometimes, but other times the combo box only gets populated with a subset of
the desired records. This subset is sometimes, but not always, the same.
I've got the same problem in another database that is all MSAccess (no MSDE
backend). For some reason the combo box does not fill up completely. This
occurs with other users also, not just me.
Windows 2000 Pro with MSAccess 2000, MSDE 2000 with all updates to Windows,
Office, MSDE, MDAC2.8.