J
Jaybird
Is it possible to filter a continuous form based on a text box in the form's
header? My form is based on a query that joins my Orders table with my Order
Details table on the Order ID field. The details section contains
information from the Order Details table while the header section contains
information about the order as a whole. What I'd like to do is filter the
information in the details section by the Order ID in the header.
The reason I want it is this: Right now for my Order Entry function I've
got a form based on my Orders table and a subform based on the Order Details
table, joined on the Order ID field. It works fine, but conducting searches
and filters and sorts by the data on my form is problematic. I've devised
the form I described above to act as sort of clone for my Order Entry form.
It is non-updatable but restores the search/filter/sort functionality. I was
thinking that it would be used for quickly finding information about sales
numbers, parts in process, PO's, Specific Orders and so on... A button on
the Order Entry form would bring up the clone. Let's call it the Search
Form. On it, you can use all the filter and sort tools available in the
toolbar menu. I've created the Search Form, but would like to limit the
records in the detail section to the current record in the header section.
I am also open to suggestions for a better way to accomplish this... Thanks!
header? My form is based on a query that joins my Orders table with my Order
Details table on the Order ID field. The details section contains
information from the Order Details table while the header section contains
information about the order as a whole. What I'd like to do is filter the
information in the details section by the Order ID in the header.
The reason I want it is this: Right now for my Order Entry function I've
got a form based on my Orders table and a subform based on the Order Details
table, joined on the Order ID field. It works fine, but conducting searches
and filters and sorts by the data on my form is problematic. I've devised
the form I described above to act as sort of clone for my Order Entry form.
It is non-updatable but restores the search/filter/sort functionality. I was
thinking that it would be used for quickly finding information about sales
numbers, parts in process, PO's, Specific Orders and so on... A button on
the Order Entry form would bring up the clone. Let's call it the Search
Form. On it, you can use all the filter and sort tools available in the
toolbar menu. I've created the Search Form, but would like to limit the
records in the detail section to the current record in the header section.
I am also open to suggestions for a better way to accomplish this... Thanks!