I have this piece of code:
SELECT DISTINCT tbl_collectBills.Truck, tbl_collectBills.Branch
ORDER BY tbl_collectBills.Truck;
on the row source of a combo box
Basically, it selects all relevant truck numbers related to the branch, trouble is when I select one branch the truck numbers for that branch come up but if I change the branch I am still left with the initial values from selecting the branch previously ( I hope you're still with me).
I need a way of refreshing the combo boxes row source when the branch is updated, I'm a little stuck
do I have to use me. to reference the control then me.requery? Along those lines?
Thanks in Advance