Unanswered: Listbox Throwing Up 11 Results as Opposed to 1
I have created a form with simply a combo box and a listbox. The listbox has a query within it with 2 fields. One is a name field and the other searches for the entry in the combo box and such has criteria
For some reason though the listbox shows 11 records for each record that is in the original table. Why would this be? I know there are 11 different choices in the combo box but I don't know why this would then translate to displaying 11 records in the listbox. Is this a common problem? I'm really stuck on finding the answer to this!
"and the other searches for the entry in the combo box and such has criteria "
I suspect this was vague to you too when you added it. The combo box and listbox are apparently meant to be connected where the listbox is supposed to show more information about the selected entry in the combo box, right? (If not, please explain)
The answer about the cascading tutorial is probably the right answer. Another possibility is to set a global variable with code when you select an entry in the combo box and write a function to return that value in the criteria of the listbox. Sounds complicated, and is a little but is an option.