I have a customer table of which a small percentage of customers are in a recurring monthly billing program, a check box separates the two groups of customers.
Every month I get an excel sheet that tells which customers had a successful auto payment processed. I import the sheet to a new table called AccountPayments.
I want to be able to view the AccountPayments data from only customers that are in the monthly billing program (checkbox = true). Joining the two tables and achieving the results via query join type gets me the information I want but I can’t edit field data once the join is created. A form/subForm is also not an ideal situation.
Ideally VBA will filter out customers that no longer have active billing charges
so when I open a form of AccountPayments table data VBA only returns account Payments from current customers (checkbox = true) from the Customer table.