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

Access 2007 Combo Boxes: Setting Default Value

kmartinenko
P: 12
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
Share this Question
Share on Google+
2 Replies


rsmccli
P: 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
Expert Mod 15k+
P: 31,494
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.