Select query in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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;
 
This question been asked before,
an answer give by Arvin Meyer

The maximum data is 2 GB, but you really should be moving to a different
engine before then. You can have about 2000 tables open.

If you open Help and type "specification" into the index (without the
quotes) you'll get lists of Access specs.
 
Back
Top