results not displaying correctly.

[teiben]

ComboboxA displays products comboboxB displays subproducts fo comboboxA - this works fine, but I have a frmResults that opens when comboboxB is selected and it doesn't open to the correct one. frmResults rowsource is the combobox rowsource: if I select comboboxA the form opens to the wrong record, if I changed it to comboboxB then I receive no records. I've looked at the code for doing 3 combobox with no problem. Has anyone done this before 2 combos and a form (not subform)

 

[gemma-the-husky]

look at the query driving frmresults

that needs to be looking at comboboxb, and maybe comboboxa also

depending on your code, you may also need to refresh the query when you change comboboxa or comboboxb

 

[teiben]

thanks, I figured that. Do you know of a similar sample somewhere, since I'm certain it was down somewhere else before