Hi,
I need to make a subform on my main form show 2 fields from the filtered recordset of the main form.
right now i just have the query set to mimic where the main form record is.
it is:
SELECT qryOpenOrdersByCustomer.SO, qryOpenOrdersByCustomer.Notes2
FROM qryOpenOrdersByCustomer;
what i would like to do but not sure how, is if I have the main form filtered to 5 records, i want the subform to show those 5 records in datasheet view.
Will someone please teach me how to do this!
thanks,
BJF
I need to make a subform on my main form show 2 fields from the filtered recordset of the main form.
right now i just have the query set to mimic where the main form record is.
it is:
SELECT qryOpenOrdersByCustomer.SO, qryOpenOrdersByCustomer.Notes2
FROM qryOpenOrdersByCustomer;
what i would like to do but not sure how, is if I have the main form filtered to 5 records, i want the subform to show those 5 records in datasheet view.
Will someone please teach me how to do this!
thanks,
BJF