[MS_AccessPros] Re: Dependent combo boxes

 

OK - I entered )=[Forms]![frmCars]![cmbCarNumber].[Value in the criteria box. I get a parameter dialog box.  When I enter a car name it returns the cars for that car name.  The SQL statement is:

SELECT tblCars.CarName,tblCars.CarNumber FROMtblCars WHERE(((tblCars.CarName)=[Forms]![frmCars]![cmbCarNumber].[Value])) ORDER BY tblCars.CarName;

Bob

__._,_.___

---

Posted by: bburke@swiftaz.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (14)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___