W
Wang
Hello,
Access 2007 has a Split-form wizard for form with subform.
I am using a table simular to the Assets Template that lists owners and
storage bins and shows all records in subform.
I want to have CBO_Storage_Bin and CBO_Owner in Header that pulls from table.
I need to filter the records in the subform in response to the dropdown
showing all records by a single owner or a second CBO to show all records at
a single location such as A1, B2, etc.
I would then like to print or email the list of filtered records as shown in
the subform.
I thought this would be easy but having gone through MS Inside/Out and MS
Building Apps has not brought the solution for forms. Tks!!
Access 2007 has a Split-form wizard for form with subform.
I am using a table simular to the Assets Template that lists owners and
storage bins and shows all records in subform.
I want to have CBO_Storage_Bin and CBO_Owner in Header that pulls from table.
I need to filter the records in the subform in response to the dropdown
showing all records by a single owner or a second CBO to show all records at
a single location such as A1, B2, etc.
I would then like to print or email the list of filtered records as shown in
the subform.
I thought this would be easy but having gone through MS Inside/Out and MS
Building Apps has not brought the solution for forms. Tks!!