Combo box behavior on first control in form
I have an access97db that has a row of 5 combo boxes that the user selects
one after the other to drill down to a specific Make,Model,Style, and year
range of vehicle. The boxes use distinct queries as follows -
1) cboVehMake - Shows every make in database. User can select one or if no
selection,the field defaults to all makes.
2) cboVehModel - Shows every model in database that matches the make in box
1. No selection defaults to
all models.
3) cboVehStyle - Shows every style that matches 1 & 2(Make & Model). No
selection defaults to all Styles.
4) cboFromDate - Shows every year that matches 1,2,3(make,model,style)
defaults to Earliest Year.
5) cboToDate - Shows every Year >= cboFromDate defaults to Latest Year
The SQL all works Great.
This is my problem
I want the list to drop down automatically on the active control so I have
control.dropdown in the control_gotfocus for each combobox. The problem is
that when the form first loads and goes to the first
combobox (cboVehMake) the list drops but it is detatched and starts about 3
inches below the text portion
of the ComboBox. Once you click on the control, the list jumps up where it
is supposed to be and is fine from
then on. All the other control dropdowns work fine from the start.
I have found this to be true even on a bare form with only a single
control (a comboBox)
Can someone else try this and let me know if it is an Access bug or
something corrupted on my machine?
just open a new form and add a combobox to it.Add the .dropdown on the
setfocus event. you don't even need to designate a data source. just run the
form and see if the box is up top and the list(grey outline if no
data source) is detatched and down.
Please let me know as this is driving me nuts!
If it is a bug, can someone show me a workaround?
