John, here is a paste of the SQL statement; I think the spaces are correct here:
SELECT tblCars.CarName, tblCars.CarNumber
ORDER BY tblCars.CarName;
The parameter dialog box work correctly, that is, when I enter, for example, "BN" it returns all the car numbers for "BN". What I need to do is to be able to select a Car Name from a drop-down box, then have the car numbers show in another drop-down box. These car name and numbers will be put into a report that the train operators can use to pick up and set out cars. There may be 6 or 30+ cars. The report also includes car type and length. It will also include a town, supplier, and contents. My question is, how do I go from the parameter dialog box to a drop-down box?
Posted by: John Viescas <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (17)|