New tab on the form.

[Danden]

Hello,
can someone help me to resolve this problem.
I want to add a new tab "Debt" in CustomerDetail form. So, I want that when I click tab "Dept" to get listing the customers who are in debt to the company.
How can I get a Dept information for that Customer in a Deptform?
What is the way to do it? Dept information are stored in Dept table.

 

[rzw0wr]

I would start with a query that filtered the customers with a debt.
Bind the DebitForm to this query.
Add the new button to open a form the read all records.
Docmd.Openform "DebitForm"

Dale