Well,
If anyone is interested, here is the solution I came up with.
In this file, everything works except the "Number of Items" box. The reference I have in the OnCurrent Event works for every one of my databases, and I don't quite understand why it doesn't work here. But anyway, Beany, if you're going to look at this, I put all of your code into a module so it didn't get erased, and I added all the code (which wasn't much!) that is needed to the two forms' events. You can look at if you like.
And by the way, I think it's about time that I chime in with this little statement...
Most of the problems with technology (that I have seen anyway) are brought on by users who, quite frankly, don't know what in the world they're doing. It is because of this phenomenon, that there is no quick fix to a problem, especially yours Beany. Another good point...anyone who tells you otherwise would probably be better off talking to a doorknob. At least their words would be put to good use by doing that!
In short, working with any kind of technology, especially complex software, takes a long time to learn and digest. The form you have now is OK, but getting all the pieces of code and objects to work together was the problem.
Another thing I should I point out is that questions that are not fully detailed (with all relevant information) on the original post are less likely to be answered successfully. If you don't know what information is relevant, the best thing to say is
"I want "X", and I don't know where to start". That way, if someone replies, they will know (if they are the least bit competent, that is), at least, how to get you started, even if they don't fully understand the complexity of the solution needed. That is a general note, and one that can surely solve a lot of problems that build up during the course of a conversation that are not present before the conversation even begins.
Anyway, if you're interested in what I've put together, you can have a look see. The only thing this doesn't do, is filter the subform appropriately if a user wants to search on more than one combo box. I didn't think you were asking that, but if you were, you will have to expand on this. Let me know what you think...
One more thing, the explanation you gave to me after I asked the questions that I did was EXCELLENT!! That is clear cut, gives all the details needed, and will get you a COMPLETE answer to your question. Who knows, by asking it that way, somebody might even help you rework your issues, like I did.
