APD Toronto
asked on
Subform Does not read recordset
Hello Experts,
I have the following query qryDiscrepancies
Here frmDiscrepDetails is a parent form and with in it I have a subform, whose record source = qryDiscrepancies
However, when I load the parent form, the subform is empty, but while the parent form is still loaded if I run qryDiscrepancies I get the needed records in the query view, but never in the subform.
What am I doing wrong?
I have the following query qryDiscrepancies
SELECT tblReservations.*
FROM tblReservations
WHERE (((tblReservations.fldTripSubType)=[Forms]![frmDiscrepDetails]![txtTripID]));
Here frmDiscrepDetails is a parent form and with in it I have a subform, whose record source = qryDiscrepancies
However, when I load the parent form, the subform is empty, but while the parent form is still loaded if I run qryDiscrepancies I get the needed records in the query view, but never in the subform.
What am I doing wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER