J
jackrobyn1
I have a form called [vehicles] that stores the vehicle fleet number,
registration number, vehicle type etc etc, that has a sub form called
[roadcalls] on it that takes its data from a query called [roadcallsQRY]
which in turn queries data from the roadcallsTBL. The vehicle
roadcalls(breakdowns and roadrepairs) are entered on a different form. I want
the query to......
1. display the roadcalls in the subform for the vehicle that matches the
record im looking at (the vehicle form only displays one vehicle at a time)
2. Also I would like to have an unbound field (possibly) on the sub from
that the query refers to so if I enter "OVERHEATED" in the field the query
then gives me the times this vehicle has been reported as overheated. This
info is in a field called defects.
registration number, vehicle type etc etc, that has a sub form called
[roadcalls] on it that takes its data from a query called [roadcallsQRY]
which in turn queries data from the roadcallsTBL. The vehicle
roadcalls(breakdowns and roadrepairs) are entered on a different form. I want
the query to......
1. display the roadcalls in the subform for the vehicle that matches the
record im looking at (the vehicle form only displays one vehicle at a time)
2. Also I would like to have an unbound field (possibly) on the sub from
that the query refers to so if I enter "OVERHEATED" in the field the query
then gives me the times this vehicle has been reported as overheated. This
info is in a field called defects.