R
Ron
Ok gang, I have an issue that's been plaguing me for quite
some time. I have a form bound to a query which is linked
to a subform. This subform is also bound to its own query.
-----------------
frmSelectInfo
qrySelectInfoSearch
-----------------
sfmScriptJobTracking5
qryJobTrackingQuery
Now on the Form are 3 unbound comboboxes
[cbxProduct], [cbxMedia], [cbxBillingType] that each
reference their respective tables for values that the user
can choose in order to retrieve records matching the
criteria in those cbxs. The records would then display in
the subform - which they do but not completely.
If you choose criteria in 1 or all 3 combo boxes, only the
very first set of records is returned in the subform. You
actually have to scroll through the records on the main
form to see the other records in the subform.
Is there a way to correct this so that all records will
show up in the subform?
Thanks in advance.
Ron
some time. I have a form bound to a query which is linked
to a subform. This subform is also bound to its own query.
-----------------
frmSelectInfo
qrySelectInfoSearch
-----------------
sfmScriptJobTracking5
qryJobTrackingQuery
Now on the Form are 3 unbound comboboxes
[cbxProduct], [cbxMedia], [cbxBillingType] that each
reference their respective tables for values that the user
can choose in order to retrieve records matching the
criteria in those cbxs. The records would then display in
the subform - which they do but not completely.
If you choose criteria in 1 or all 3 combo boxes, only the
very first set of records is returned in the subform. You
actually have to scroll through the records on the main
form to see the other records in the subform.
Is there a way to correct this so that all records will
show up in the subform?
Thanks in advance.
Ron