Hello,
A subform has 4 fields, State, Location ID, Total and District.
For the first 3 fields ( State, LocationID, Total ) the data is obtained using a query 1. This is set up in the design mode
For the last field, District, data needs to be obtained by passing locationID to
Table 2.
E.g. select district from table 2 where ID = @locationID
How can I write a query where locationID is passed as a parameter in the design mode
Please if there is a easier better way of handling this do let me know.
Thank you
D
A subform has 4 fields, State, Location ID, Total and District.
For the first 3 fields ( State, LocationID, Total ) the data is obtained using a query 1. This is set up in the design mode
For the last field, District, data needs to be obtained by passing locationID to
Table 2.
E.g. select district from table 2 where ID = @locationID
How can I write a query where locationID is passed as a parameter in the design mode
Please if there is a easier better way of handling this do let me know.
Thank you
D
