Subform not displaying all records from criteria chosen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top