By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

trying to force a combo box to update

P: n/a
I have a combo box that when you go to the next combo box it is
filtered based on the value in the previous one.

so if combo box 1 has fred as its value then combo box 2 has
1 2 3 for values.

this works fine the first time thru.

but later if I change combo box 1 combo box 2 list is still displaying
the list form the previous value in combo box 1.

its a timing error or something since I can click the row source
that is a sql statement and go to the query and come back and then box
2 is displaying the correct values.
so 1 sets 2 but after I chance 1 2 is still displaying the old list
based on what it was filtered in by 1.

me.requery does nothing to help..on after update or combo box 1
any help is greatly appreciated...I just can't get 2 to update when 1
is changed.
Feb 16 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
In the AfterUpdate event of combo1 put the line:
combo2.requery

Cheers,
Jason Lepack
On Feb 16, 9:39 am, sparks <jstal...@swbell.netwrote:
I have a combo box that when you go to the next combo box it is
filtered based on the value in the previous one.

so if combo box 1 has fred as its value then combo box 2 has
1 2 3 for values.

this works fine the first time thru.

but later if I change combo box 1 combo box 2 list is still displaying
the list form the previous value in combo box 1.

its a timing error or something since I can click the row source
that is a sql statement and go to the query and come back and then box
2 is displaying the correct values.

so 1 sets 2 but after I chance 1 2 is still displaying the old list
based on what it was filtered in by 1.

me.requery does nothing to help..on after update or combo box 1

any help is greatly appreciated...I just can't get 2 to update when 1
is changed.

Feb 16 '07 #2

P: n/a
That was it....I almost said that didn't work till I found out I
either can't type or can't spell.....which ones sounds better LOL

thanks for your help

On 16 Feb 2007 06:47:11 -0800, "Jason Lepack" <jl*****@gmail.com>
wrote:
>In the AfterUpdate event of combo1 put the line:
combo2.requery

Cheers,
Jason Lepack
On Feb 16, 9:39 am, sparks <jstal...@swbell.netwrote:
>I have a combo box that when you go to the next combo box it is
filtered based on the value in the previous one.

so if combo box 1 has fred as its value then combo box 2 has
1 2 3 for values.

this works fine the first time thru.

but later if I change combo box 1 combo box 2 list is still displaying
the list form the previous value in combo box 1.

its a timing error or something since I can click the row source
that is a sql statement and go to the query and come back and then box
2 is displaying the correct values.

so 1 sets 2 but after I chance 1 2 is still displaying the old list
based on what it was filtered in by 1.

me.requery does nothing to help..on after update or combo box 1

any help is greatly appreciated...I just can't get 2 to update when 1
is changed.
Feb 16 '07 #3

P: n/a
Fat thumbs... ;)

Glad to hear it worked.

On Feb 16, 10:11 am, sparks <jstal...@swbell.netwrote:
That was it....I almost said that didn't work till I found out I
either can't type or can't spell.....which ones sounds better LOL

thanks for your help

On 16 Feb 2007 06:47:11 -0800, "Jason Lepack" <jlep...@gmail.com>
wrote:
In the AfterUpdate event of combo1 put the line:
combo2.requery
Cheers,
Jason Lepack
On Feb 16, 9:39 am, sparks <jstal...@swbell.netwrote:
I have a combo box that when you go to the next combo box it is
filtered based on the value in the previous one.
so if combo box 1 has fred as its value then combo box 2 has
1 2 3 for values.
this works fine the first time thru.
but later if I change combo box 1 combo box 2 list is still displaying
the list form the previous value in combo box 1.
its a timing error or something since I can click the row source
that is a sql statement and go to the query and come back and then box
2 is displaying the correct values.
so 1 sets 2 but after I chance 1 2 is still displaying the old list
based on what it was filtered in by 1.
me.requery does nothing to help..on after update or combo box 1
any help is greatly appreciated...I just can't get 2 to update when 1
is changed.- Hide quoted text -

- Show quoted text -

Feb 16 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.