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

Don't Drop Down Combo Box

P: 8
I have the following code in the NotInList event of my combo box:
Expand|Select|Wrap|Line Numbers
  1.    Me.cboQuestionNumber.Undo
  2.    MsgBox "That is not a valid Control Number for the questions you have " _
  3.      & "selected to have displayed. You may need to alter your search criteria " _
  4.      & "to find this question."
  5.    Response = 0
  6.  
This works fine except that it opens up the combo box to show the users what selections are available. How do I keep the combo box from opening up?

Thanks!
Lena
Nov 21 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
The nature of a combobox is to drop down. If you don't want the users to see this change it to a textbox and use some other way to check for the value like a DLookup in the after update event of the textbox.

If this doesn't suit for some reason, tell me the logic behind what you're doing and I'll try to come up with another solution.

Mary


I have the following code in the NotInList event of my combo box:
Expand|Select|Wrap|Line Numbers
  1. Me.cboQuestionNumber.Undo
  2. MsgBox "That is not a valid Control Number for the questions you have " _
  3. & "selected to have displayed. You may need to alter your search criteria " _
  4. & "to find this question."
  5. Response = 0
  6.  
This works fine except that it opens up the combo box to show the users what selections are available. How do I keep the combo box from opening up?

Thanks!
Lena
Nov 21 '06 #2

Post your reply

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