#1
|
|||
|
|||
Combo Box in VB Forms help
Code:
If addtacourt.Value Is Empty Then 'combobox MsgBox ("You must choose a court of Jurisdition") addtacourt.SetFocus Exit Sub Else End If I have tried . text and =""' With the Sample attached run ADDTA form in vb Use zip 71295 in zip code as I know it is in there (only LA<AR<MS states are in the zipcode range) Why does this work with textbox but not with combobox? Last edited by Cbrehm; 05-12-2011 at 03:36 PM. |
#2
|
||||
|
||||
Hi cbrehm,
There's no code in the workbook, which rather makes code testing rather difficult.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Well slap me silly. I changed it out to one that does have code. Sorry about that
|
#4
|
||||
|
||||
Hi cbrehm,
You'll find your combobox works better if you call it by its name, instead of by the name for a button on your form ...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thanks. I have a list posted on the wall of what names go to what and just named the command button and the combobox backwards when I set the form up.
|
#6
|
||||
|
||||
It's the little things that bite!
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box populate from range | ioustinos | Excel | 1 | 09-01-2010 09:18 AM |
Combo Box in whole column | ioustinos | Excel | 1 | 09-01-2010 01:24 AM |
Forms - Combo Box Linking data | tomkat | Word | 1 | 04-23-2010 06:28 AM |
VB Code.. COmbo boxes | DrewB | Word VBA | 4 | 06-10-2009 05:31 AM |
Hide a combo box | DrewB | Word | 3 | 06-08-2009 11:29 PM |