VBA table filter

[ShostyFan]

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.

[rpeare]

Does each of your tables have a primary key field?

If neither has a primary key you won't be able to create an updatable query.
If one of your tables has a primary key but the other doesn't the link must include the primary key field.

In other words your ACCOUTPAYMENTS, I'm guessing, has a primary key, but it's an autonumber or something. *NOT* the customerID which is what you'd need to link to the customer table to find out which ones were on a billing program. If you can not/do not want to use a form/subform arrangement you may need to use some unbound controls to be able to do the data entry and not create the form on a non-updatable query.