Hi,
I have a database for biological monitoring data of birds and mammals. The monitoring is done along line transects of 1000m, with 'point stations' every 200m (so 6 stations per transect).
There is a table for the transects ('Transects') containing the following fields:
'Transect ID', 'Transect name', etc...
There is a separate table for the transect point stations ('Stations'), containing the fields:
'Station ID', 'Transect ID' (referring to the Transect table).
There is an overarching form ('Input sessions2') for data input info (date of input, etc.),
in the first subform (Visit Info1) the visited transect is specified from a combo listing all possible transect ID from the Transects-table.
In the sub-subform (Mammal observations), all observed mammals are entered. The station where it was observed, is selected from a combo (MobsTransect) listing all Station ID from the Stations-table.
However, I want the choice of stations in the MobsTransect combo to be limited to the stations that are actually located on the transect specified in the first subform (Visit Info1)... in other words, only stations that have the specified transect as 'Transect ID' in the Stations-table should be selected.
I used several methods to get this selection, but I assume I make the same mistake in all of them...
the Row Source specified as follows:
SELECT [Station ID] FROM Stations WHERE [Transect ID] = [Forms]![Input sessions2].[Visit Info1].Form![Transect] ORDER BY [Station ID];
The sql looked as follows:
SELECT Stations.[Station ID]
FROM Stations
WHERE (((Stations.[Transect ID])=[Forms]![Input sessions2].[Visit Info1].[Form]![Transect]))
ORDER BY Stations.[Station ID];
It keeps on asking to specify the parameter '[Forms]![Input sessions2].[Visit Info1].Form![Transect]', so I suppose the reference to the subform (Visit Info1) is not correct... but I can't figure out what is wrong..
Any thoughts on this?
(I tried to upload the empty database, but it's a complicated one and too big to send..)
-