John, here is a paste of the SQL statement; I think the spaces are correct here:
SELECT tblCars.CarName, tblCars.CarNumber
FROM tblCars
WHERE (((tblCars.CarName)=[Forms]![frmCars]![cmbCarNumber].[Value]))
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?
Thanks,
Bob
Posted by: bburke@swiftaz.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (16) |
Tidak ada komentar:
Posting Komentar