Howdy, Pavel.
Thanks for your suggestion. Unfortunately, it won't work as there there are
5 fields in the subform but the first (visitnum) is set as no tab stop so
there are 4 tab stops only with visittype (1) and counselor (4). Also the
user enters the visit info in order of typem date, reasons, counselor.
What I want the combobox to do is dropdown when I arrive on field AND not
dropdown when I cycle through client records. BTW, this is Access97, if I
didn't mention it before.
The dropdown issue is that as I cycle through the client records, the
subform will drop down the visittype or counselor field depending on which
field I've uncommented the obj.dropdown code.
If I enter a new visit info and am in the Counselor field when I click the
Save btn AND then move to the next client record via the record selector,
the Counselor field will drop down. So I now have to move to the reason
field in the subform to remove the focus from the counselor field so that it
does not drop down on cycling through clients. If I move the cursor to the
first name field on the form from the counselor field, the counselor field
still drops down on cycling through clients. It also drops down if I click
on Save btn, which I have now modified to setfocus to first name field.
Even changing code to dropdown on enter vice gotfocus does the same. So
maybe the option is not to cause the combo to dropdown.
Hopefully this provides you more detail.
Thanks again,
Rey
"Pavel Romashkin" <pa*************@hotmail.com> wrote in message
news:3F***************@hotmail.com...
Ok, I see what's happening. Now, could you tell what do you *want* to
happen? If you don't want the dropdown to occur on record changes, set tab order
for the combo box to something other that 0 or 1 so that they don't get
focus immediately.