hoschi
Registered User.
- Local time
- Today, 10:54
- Joined
- Sep 11, 2002
- Messages
- 16
I got three combo boxes with this code...
one table: tblTest with these attributes: land = country, stadt = city and einwohner = habitant
the boxes are filtered, so i can only choose the cities which are in the country i decided in the box above...
box 1
SELECT DISTINCT tblTest.land FROM tblTest ORDER BY tblTest.land;
box 2
SELECT DISTINCT [tblTest].[stadt], [tblTest].[land] FROM tblTest WHERE ((([tblTest].[land])=[Forms]![frmTest1]![land])) ORDER
BY [tblTest].[stadt];
box 3
SELECT DISTINCT [tblTest].[einwohner], [tblTest].[stadt] FROM tblTest WHERE
((([tblTest].[stadt])=[Forms]![frmTest1]![stadt])) ORDER BY [tblTest].[einwohner];
i want to add to the form a button which saves the chosen information in a other tabel perhaps tblTest2...
how can i do this...
thanx
hoschi
one table: tblTest with these attributes: land = country, stadt = city and einwohner = habitant
the boxes are filtered, so i can only choose the cities which are in the country i decided in the box above...
box 1
SELECT DISTINCT tblTest.land FROM tblTest ORDER BY tblTest.land;
box 2
SELECT DISTINCT [tblTest].[stadt], [tblTest].[land] FROM tblTest WHERE ((([tblTest].[land])=[Forms]![frmTest1]![land])) ORDER
BY [tblTest].[stadt];
box 3
SELECT DISTINCT [tblTest].[einwohner], [tblTest].[stadt] FROM tblTest WHERE
((([tblTest].[stadt])=[Forms]![frmTest1]![stadt])) ORDER BY [tblTest].[einwohner];
i want to add to the form a button which saves the chosen information in a other tabel perhaps tblTest2...
how can i do this...
thanx
hoschi