G
Guest
I need to filter a main form based on fields in my subform. For example, my
main form has a field [Order Number] and the header contains standard
information about the origin of the parts and what is to be done with them,
like the PO Number, and Customer information. My subform contains
information like the Part Number, Qty, the ID Number for that particular line
item, etc. My boss needs to be able to tell how many orders contain Part
Number so and so... information that is specific to the underlying table in
the subform, but he also needs the associated information in the main form.
Before I normalized the table structure, all of this information was
contained on one table, and could easily be searched and sorted and filtered
using the tools on the menu bar. Well, I've gone and screwed that all up,
and the users are gunning for my blood. I need to restore these features
pronto. I attempted to implement Allen Browne's 'Filter a Form on a Field in
a Subform' at: http://allenbrowne.com/ser-28.html but I had a lot of trouble
with the coding. I couldn't get my SQL to be accepted as my new
recordsource. Anyhow, I'm thinking of dropping that technique in favor of a
popup form that contains the queried information, using a query as the
recordsource that includes the table from the subform as search criteria.
It's working, but I just thought I'd ask if you guys thought I did the right
thing.
main form has a field [Order Number] and the header contains standard
information about the origin of the parts and what is to be done with them,
like the PO Number, and Customer information. My subform contains
information like the Part Number, Qty, the ID Number for that particular line
item, etc. My boss needs to be able to tell how many orders contain Part
Number so and so... information that is specific to the underlying table in
the subform, but he also needs the associated information in the main form.
Before I normalized the table structure, all of this information was
contained on one table, and could easily be searched and sorted and filtered
using the tools on the menu bar. Well, I've gone and screwed that all up,
and the users are gunning for my blood. I need to restore these features
pronto. I attempted to implement Allen Browne's 'Filter a Form on a Field in
a Subform' at: http://allenbrowne.com/ser-28.html but I had a lot of trouble
with the coding. I couldn't get my SQL to be accepted as my new
recordsource. Anyhow, I'm thinking of dropping that technique in favor of a
popup form that contains the queried information, using a query as the
recordsource that includes the table from the subform as search criteria.
It's working, but I just thought I'd ask if you guys thought I did the right
thing.