469,613 Members | 1,739 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,613 developers. It's quick & easy.

Access 2007 Combo Boxes: Setting Default Value

kmartinenko
Hi everyone,

I have several combo boxes on my form, and while I have designated a column head, I cannot figure out how to default to the column head value. What I really want is for all of my combo boxes to default to a selection that is either blank or the column head, so that my users don't see their previous selection when they go and select a value from the drop down list.

Also, what would be the best way to enable a user to clear out a form (reset all combo boxes to blank fields) so that they aren't running a report on a previous entry? I have tried creating a reset form command button, and while it is effective in function, it doesn't automatically clear the previous selections out and return each combo box to its default value.

Thanks,

Kindra
Apr 30 '08 #1
2 6251
rsmccli
52
Hi everyone,

I have several combo boxes on my form, and while I have designated a column head, I cannot figure out how to default to the column head value. What I really want is for all of my combo boxes to default to a selection that is either blank or the column head, so that my users don't see their previous selection when they go and select a value from the drop down list.

Also, what would be the best way to enable a user to clear out a form (reset all combo boxes to blank fields) so that they aren't running a report on a previous entry? I have tried creating a reset form command button, and while it is effective in function, it doesn't automatically clear the previous selections out and return each combo box to its default value.

Thanks,

Kindra
What is the code on your reset form command button and the names of your combo boxes?

How could the reset form command button be "effective in function" but still not do what you want it to. Just wondering.
Apr 30 '08 #2
NeoPa
32,200 Expert Mod 16PB
The usual way to set a ListBox or ComboBox to a particular value is a little strange, but it is to set the value of the control to the value of the line you want selected.

In your case I would try setting it to either the text in the heading or blank, depending on what's required.
May 1 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Heather | last post: by
2 posts views Thread by Sean | last post: by
3 posts views Thread by =?Utf-8?B?Y2RtdW5veg==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.