I have two tables one lists jobs and the other list destinations of those
jobs they are tied together by jobnumber.  I want to be able to limit what
you see when you enter a delivery into a form.  I am trying to restrict the
delivery sites to the ones only connected to that job.  I have entered the
following in the combo box row source of my form, but it will only work once
and then it leaves those for the next form no matter what job number you
enter.  Where have I gone wrong?  Thanks

SELECT Delivery.destination FROM Delivery WHERE
(((Delivery.jobnumber)=Forms!loads!jobnumber)) GROUP BY Delivery.destination
ORDER BY Delivery.Destination;