trying to force a combo box to update

[sparks]

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.

[Jason Lepack]

In the AfterUpdate event of combo1 put the line:
combo2.requery

Cheers,
Jason Lepack
On Feb 16, 9:39 am, sparks <[e-mail]:

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.

[sparks]

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 <[e-mail]:

>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.

[Jason Lepack]

Fat thumbs... ;)

Glad to hear it worked.

On Feb 16, 10:11 am, sparks <[e-mail]:

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" <[e-mail]>
wrote:

In the AfterUpdate event of combo1 put the line:
combo2.requery

Cheers,
Jason Lepack

On Feb 16, 9:39 am, sparks <[e-mail]:

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 -