Got back to it after the long weekend. Thank you all for your replies--I double-checked and tried everything you all suggested. I got kind of close but not quite there. I tried writing a new query to pull the RepID, and the two other fields from their respective tables--it will return one text...
It's been a couple years since I've dabbled in building a database, and I'm working on one that's nearly complete except for this one issue I'm trying to solve. I'm trying to create a combo box on a form based on a table that displays two text fields (while hiding the PK, so a 3-column box) that...
Ahhhh. and when I was reviewing everything I missed the one. Thank you so much for spending all this time on this! I feel rather silly for not noticing the one odd-ball record.
Guess I'm off to write a query to find and delete records that are null now so there's a quick fix if that ever...
First box tried 10007 = got error. Tried a few others, all gave errors.
Second box 10007 = worked
10125 = worked
10135 = worked
10156 = worked
10201 = worked
10235 = error.
10210 = error.
90100 = error
Right now there are 666 records. That's not a pleasant number--ha! And I'm not even 1/4 of the way done with entering things.
How would I check if what's stored is different from what's displayed?
OK, so this is interesting:
Made a new cbo box on my form using the wizard. Set the format to "general number" since the column in the table it is referencing is set to "number"
All of my original 5-digit IDs all start with 10. If I start typing 10 and the next number is 0, 1, or 2, it...
Worked like a dream. I did notice that when I changed it to DataEntry > yes it would not display anything (didn't get the error though!). when I changed it to "no" it would work just fine, no errors, and display everything. My form is a data entry form, so could the issue be that I have data...
oops, yeah, every time I said "6-digit" I guess I meant 5-digit. I pulled up my data entry form (same form I'm trying to get this CBO box to work in) and just added 90 to the beginning of the ID number and saved.
So I tried changing the 3-digit IDs to 6-digit, and same thing. When I try to type anything longer than 3-digits in the cbo it tells me it's not an item on the list.