CombObox Issue 1

[DMBLuva]

Good Morning,
I have searched the forums for my question, I'm sure there is something I have missed. I have two pesky comboboxes that refuse to show the table contents. I have checked my options in both the form and the tables and cannot see where I have gone wrong.

What I have is one table that contains department names and the other that contains categories. In the properties of the main table, each are set to combobox and are pointed to the tables along with bound column 1 and column count 1. Since they do not need to be linked, only read, I have only set them up as data tables to pull from. Trouble I am having is when you view the dropdown information, it's blank. No data shows up. but if I change the limit to list to yes, it says that that whatever I type in (in the table or not) is not on the list.

I have to be missing something. I apoligize if this turns out to be some stupid overlooked error. I appreciate all you help.

 

[fneily]

Did you use the Combobox Wizard to create your comboboxes? Do that first. Also, check what's in your Column Widths option.

Also, try and watch your language. You state:
"In the properties of the main table," I guess you mean form.
"I have only set them up as data tables to pull from." No. They're comboboxes.
It gets confusing.

 

[DMBLuva]

Thanks for the notes. I will take them into account for my next question. It's hard to describe without coding heh.
I took your advice and used the wizard, but it still shows blank in the drop down. I'm not sure where to go next. My other comboboxes work, but they are pulling from a different linked source. Strange.
One thing I did notice was when I was using 2007 version, it showed with no problem. The users with the 2003 version however were having the same issue I am now. I was recently moved back to version 2003. The database was built initially in 2003 version.
I hope I make sense.
thanks for your help!!! Much appreciated.

 

[fneily]

Well, anytime you try and grow younger, there'll be problems. 2007 to 2003. Since your users are in 2003, build the forms in 2003. So try and just rebuild the combobox in 2003.

 

[fneily]

Also, if it still doesn't work, post the rowsource and rowsource type.

 

[missinglinq]

Unfortunately, you've apparently updated to the SP3 service pack for Access 2003 and it's buggier than the Great Dismal Swamp! One of the most common bug reported involves comboboxes with disappearing data! The field(s) in the cbo, in the underlying table, have some kind of formatting in place. This is often the simple > used to force UpperCase. Remove any formatting from the fields and things should work short term, but the definitive solution is to install the hotfix for SP3.

Here's a link to Allen Browne's site where you can find the latest news about these bugs, as well a link to the Hotfix:

http://allenbrowne.com/bug-Access2003SP3.html

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[DMBLuva]

missinglinq you are so great!!! That fixed it. That has been bugging me for SOOOO long!!! Thank you for your help. fneily thank you for your help as well!!!

 

[fneily]

I bow to missinglinq. I keep forgetting about those updates. Good call.

 

[missinglinq]

fneily, that's because you probably have a real job while I, being in forced retirement, have the time to keep track of all these bugs! I troll this and other forums about 8 hours a day, and usually see and answer this particular question four or five times every single day!

;0)>

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!