Requery combo box

  • Thread starter Thread starter C. Miller
  • Start date Start date
C

C. Miller

I have a combo box that I requery based upon the results
of a previous combo box. They are both on an unbound
form. The first box allows the user to select a region
and the second a location within that region. I have the
requery command written in the on change event. It works
fine on my computer. Once I transferred it to the end
user, it doesn't work at all. We are both running Access
2000 SP-3 and SP7 of Jet 4.0. The difference is that the
user is in Windows 98 while I am in 2000. Would this make
a difference? Do I need to change which event it uses?
If so, why would the O/S make that sort of difference?

Thanks.
 
C. Miller said:
I have a combo box that I requery based upon the results
of a previous combo box. They are both on an unbound
form. The first box allows the user to select a region
and the second a location within that region. I have the
requery command written in the on change event. It works
fine on my computer. Once I transferred it to the end
user, it doesn't work at all. We are both running Access
2000 SP-3 and SP7 of Jet 4.0. The difference is that the
user is in Windows 98 while I am in 2000. Would this make
a difference? Do I need to change which event it uses?
If so, why would the O/S make that sort of difference?
Click to expand...

I've never heard of the OS making a difference with this
type of thing.

You should use the first combo's AfterUpdate event. The
Change event fires for every keystroke. The afterUpdate
event fires only after the user has completed the selection.
 
Thanks, I'll give that a try.
-----Original Message-----


I've never heard of the OS making a difference with this
type of thing.

You should use the first combo's AfterUpdate event. The
Change event fires for every keystroke. The afterUpdate
event fires only after the user has completed the selection.
Click to expand...
 
C. Miller said:
Tried that on the users machine and had no success. The
combobox updates corretly still on my machine, but shows
up blank on the users 98 machine. Same file, no
differences in data.
Click to expand...

It sounds like the the table for the second combo doesn't
have any matching records. But when you say the tables are
the same, I have no ideas beyond grasping at straws such as
a messed up reference or some other configuartion problem.
 
Back
Top