Restore combos to "blank"

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
 
S

Sandra Daigle

Just set it to Null using the AfterUpdate event of the first combo.

me.Combo1 = null
 
S

Sandra Daigle

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


.
 
A

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


.


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top