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

Empty 29 comboboxes?

P: n/a
I have a form with 29 comboboxes.
The are called me.combocg1, me.combocg2, me.combocg3 etc etc

What is the best way to empty them?

For i = 1 To 29
varCombo = "me.combocg" & i
WaardeOnthouden = ""
varCombo = WaardeOnthouden
Next

does not do the trick :s

Ideals anyone?

Suggestions ans thinking along with me are greatly appreciated!

Mar 12 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Try:

For i = 1 to 29
Me("combocg" & i) = Null
Next

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Henrootje" <He****@gmail.comwrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...
>I have a form with 29 comboboxes.
The are called me.combocg1, me.combocg2, me.combocg3 etc etc

What is the best way to empty them?

For i = 1 To 29
varCombo = "me.combocg" & i
WaardeOnthouden = ""
varCombo = WaardeOnthouden
Next

does not do the trick :s

Ideals anyone?

Suggestions ans thinking along with me are greatly appreciated!
Mar 12 '07 #2

P: n/a
Allen,

I personally will make sure that you get your own statue in the parc
where I live!
It is in Enschede, Netherlands, Europe so unfortunately you will
probably not be able to see it.
Viewing it through Google Earth might be a bit hard with alle the
trees in the parc blocking the view and all. <grin>

But rest assured that I think that you deserve a statue and you should
relish in the fact that there is one bearing your name.

Oh, and the code works swell!!!!
greetings, Henro
On 12 mrt, 12:08, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Try:

For i = 1 to 29
Me("combocg" & i) = Null
Next

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Henrootje" <Hen...@gmail.comwrote in message

news:11**********************@p10g2000cwp.googlegr oups.com...
I have a form with 29 comboboxes.
The are called me.combocg1, me.combocg2, me.combocg3 etc etc
What is the best way to empty them?
For i = 1 To 29
varCombo = "me.combocg" & i
WaardeOnthouden = ""
varCombo = WaardeOnthouden
Next
does not do the trick :s
Ideals anyone?
Suggestions ans thinking along with me are greatly appreciated!- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

Mar 12 '07 #3

P: n/a
Henrootje wrote:
But rest assured that I think that you deserve a statue and you should
relish in the fact that there is one bearing your name.

Oh, and the code works swell!!!!
Yes, we're erecting one here in St. JOhn's, Newfoundland, CAnada, as
well... 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Mar 12 '07 #4

P: n/a
"Allen Browne" <Al*********@SeeSig.Invalidwrote in
news:45**********************@per-qv1-newsreader-01.iinet.net.au:
Try:

For i = 1 to 29
Me("combocg" & i) = Null
Next
This is the kind of thing I'd use a custom collection for. I've
written about it many times in this newsgroup, so getting
instructions ought to be quite easy by some searching on this email
address and "custom collection" on Google Groups.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Mar 12 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.