Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2011, 12:56 PM
Cbrehm Cbrehm is offline Combo Box in VB Forms help Windows 7 64bit Combo Box in VB Forms help Office 2003
Novice
Combo Box in VB Forms help
 
Join Date: May 2011
Posts: 8
Cbrehm is on a distinguished road
Default 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
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?
Attached Files
File Type: xls Tax sale program.xls (274.5 KB, 8 views)

Last edited by Cbrehm; 05-12-2011 at 03:36 PM.
Reply With Quote
  #2  
Old 05-12-2011, 01:08 PM
macropod's Avatar
macropod macropod is offline Combo Box in VB Forms help Windows 7 32bit Combo Box in VB Forms help Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,701
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi cbrehm,

There's no code in the workbook, which rather makes code testing rather difficult.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-12-2011, 03:37 PM
Cbrehm Cbrehm is offline Combo Box in VB Forms help Windows 7 64bit Combo Box in VB Forms help Office 2003
Novice
Combo Box in VB Forms help
 
Join Date: May 2011
Posts: 8
Cbrehm is on a distinguished road
Default

Well slap me silly. I changed it out to one that does have code. Sorry about that
Reply With Quote
  #4  
Old 05-12-2011, 03:58 PM
macropod's Avatar
macropod macropod is offline Combo Box in VB Forms help Windows 7 32bit Combo Box in VB Forms help Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,701
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #5  
Old 05-13-2011, 02:47 AM
Cbrehm Cbrehm is offline Combo Box in VB Forms help Windows 7 64bit Combo Box in VB Forms help Office 2003
Novice
Combo Box in VB Forms help
 
Join Date: May 2011
Posts: 8
Cbrehm is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 05-13-2011, 03:08 AM
macropod's Avatar
macropod macropod is offline Combo Box in VB Forms help Windows 7 32bit Combo Box in VB Forms help Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,701
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

It's the little things that bite!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box in VB Forms help 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
Combo Box in VB Forms help Hide a combo box DrewB Word 3 06-08-2009 11:29 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft