Restore combos to "blank"

  • Thread starter Thread starter an
  • Start date Start date
A

an

On one form with combo boxes, when we data change in 1st
combo, anothers combos keep it old data.
How is possible to force to appear "blank" the following
combos in this case, please?
Thanks in advance.
an
 
Just set it to Null using the AfterUpdate event of the first combo.

me.Combo1 = null
 
Exactly.

But one small nuance:
"using the AfterUpdate event of the first combo" will be

Me.Combo2 = Null
....

Thank you for your help.
an
-----Original Message-----
Just set it to Null using the AfterUpdate event of the first combo.

me.Combo1 = null


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

On one form with combo boxes, when we data change in 1st
combo, anothers combos keep it old data.
How is possible to force to appear "blank" the following
combos in this case, please?
Thanks in advance.
an


.
 
Of course . . . unless your controls are indexed starting with 0!

I'm just playing of course but there *are* several collections in Access
that are indexed starting with 0 so it's always a good to know the starting
value!

:-)

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Exactly.

But one small nuance:
"using the AfterUpdate event of the first combo" will be

Me.Combo2 = Null
...

Thank you for your help.
an
-----Original Message-----
Just set it to Null using the AfterUpdate event of the first combo.

me.Combo1 = null


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

On one form with combo boxes, when we data change in 1st
combo, anothers combos keep it old data.
How is possible to force to appear "blank" the following
combos in this case, please?
Thanks in advance.
an


.
 
Certainly!
More one time...
Many thanks.

an
-----Original Message-----
Of course . . . unless your controls are indexed starting with 0!

I'm just playing of course but there *are* several collections in Access
that are indexed starting with 0 so it's always a good to know the starting
value!

:-)

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Exactly.

But one small nuance:
"using the AfterUpdate event of the first combo" will be

Me.Combo2 = Null
...

Thank you for your help.
an
-----Original Message-----
Just set it to Null using the AfterUpdate event of the first combo.

me.Combo1 = null


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


an wrote:
On one form with combo boxes, when we data change in 1st
combo, anothers combos keep it old data.
How is possible to force to appear "blank" the following
combos in this case, please?
Thanks in advance.
an


.


.
 
Back
Top