Search results

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

Everything worked in both! 😃 What voodoo did you do?

yes, I tried changing them to start with 90 and it did not make any difference.

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

Here you go! thank you so much for muddling through this with me. I also left the RecordID since that is the PK.

part of me wonders if I should scrap the cbo and make it a text box that runs a macro to find the record after it updates.

Ran it. Everything matched.

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

OK, not fully caffeinated yet. While I do use the form to enter data, I do have DataEntry set to No. So....it's not that. lol.

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.

No, that's fine...I'm just trying to figure out if anything you did was different from what I have. And everything looks identical. So I'm not sure why I get the error with my form. So weird.

It's working. No error. It looks like the only thing different you did was add the ItemName to the cbo?

@theDBguy Here's a copy of some of the table data the cbo is pulling from. I've tried creating a new cbo, and it does the same thing--the RecordID (PK) is hidden, the InventoryID is column 1 which is bound. It will let me type to search for anything that is 3-digits, but says anything with 6...

I'm the only one using it right now, and I don't use the recordID for anything--I have it so that it is the PK that will never change. There is the possibility that the numbering system for the InventoryID may change years from now, so I didn't want to use the same number for both the PK and...

Yes, it does. Except it does not acknowledge the items with 6-digits when I type. But I can select from the drop-down.