Combo Box in VB Forms help

Cbrehm · #1 05-12-2011, 12:56 PM

Code:

If addtacourt.Value Is Empty Then  'combobox
    MsgBox ("You must choose a court of Jurisdition")
    addtacourt.SetFocus
    Exit Sub
 Else
 End If

Returns an error
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?

macropod · #2 05-12-2011, 01:08 PM

Hi cbrehm,

There's no code in the workbook, which rather makes code testing rather difficult.

Cbrehm · #3 05-12-2011, 03:37 PM

Well slap me silly.

I changed it out to one that does have code. Sorry about that

macropod · #4 05-12-2011, 03:58 PM

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 ...

Cbrehm · #5 05-13-2011, 02:47 AM

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.

macropod · #6 05-13-2011, 03:08 AM

It's the little things that bite!

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