Find a Record on My Form Baed on the Value I Select...

[sjl]

Last night (in my development db), I created a combo box that finds a record on my form based on a value selected from a combo box. Today I have tried repeatedly to do the same in my production db, and although I can get through all the steps of the Wizard and the unbound combo box shows in Design view, no values show up in the combo box!!!? I thought at first it was the font, or Visible was set to No....but not true. I actually tried the same steps of the Wizard with another variable and that variable DOES show! Any ideas?

thanks mucho,
sjl

 

[DevastatioN]

INteresting enough it sounds like roughly the exact same problem as here:

http://www.access-programmers.co.uk/forums/showthread.php?t=163413

When you select this empty combobox, can you view the query to see if there is any data that way? If the query shows data but the combobox doesn't, it could be a binding issue.

Go to the combobox properties, select Row Source, press the three little dots beside it, then when the SQL Statement window opens, select Datasheet view and see if there's anything there. If not, the query might have been created incorrectly.

 

[sjl]

DevastatioN...

When you select this empty combobox, can you view the query to see if there is any data that way? If the query shows data but the combobox doesn't, it could be a binding issue. YES, THE QUERY SHOWS DATA.

Go to the combobox properties, select Row Source, press the three little dots beside it, then when the SQL Statement window opens, select Datasheet view and see if there's anything there. If not, the query might have been created incorrectly. YES, THE DATA IS THERE...IN THE DATASHEET UNDER THE SQL WINDOW...

I TRIED SELECTING A DIFFERENT FIELD NAME IN THE QUERY, AND THEN LOOKED AT THE COMBO BOX WHEN I BACKED OUT OF THE SQL QUERY...AND THAT DATA (FOR THAT DIFFERENT FIELD) does SHOW!!!? IS THERE SOME KIND OF SIZE LIMIT FOR COMBO BOXES?....SOME OF THE VALUES OF THE FIELD THAT WILL NOT SHOW ARE VERY LARGE: 45-50 CHARACTERS WIDE. The field size for this field is 80, and the format is > (all caps)......would these characteristics perhaps be creating a prob? Also, some of the values for this field have parens...


shooting in the dark..
sjl
​

 

[sjl]

I took out the ">" (all caps) format in the TABLE for the field that refused to show. It now shows!!? Is this some kind of Access rule for combo boxes...or just an anomaly???

thanks
sjl

 

[DevastatioN]

Weird, I ahve not come across that before... I have no further explanation

 

[DevastatioN]

I quickly created a database with a table that had the format as > and put in 5 pieces of random data.

I created a form and the combobox that looked up that data and it worked fine for me. I am using Access 2003, which version are you on?

 

[missinglinq]

Unfortunately, you've apparently updated to the SP3 service pack for Access 2003 and it's buggier than the Great Dismal Swamp! The problem you've experienced is one of the most commonly reported bugs, usually caused the by some kind of formatting. As you've seen, the simple > used to force UpperCase is one of the most common culprits. Removing the formatting from the fields works in the 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

DevastatioN either doesn't have SP3 installed, or has it installed and has also installed the hotfix.

 

[sjl]

Yep, I have SP3. Thanks for getting to the bottom of this!

To all who helped, gracias!

sjl