Query result on a form in access (1 Viewer)

Dear All;

I am developing a database, with following tables and queries for a customer management.

Table and query for customer registration
Table and query for billings
Table and query for payments

Now what I need is;

1. a query which shows the balance of customers
2. in a form that I do billing automatically the balance of customers appears.

I have uploaded the works I done (a draft), I would appreciate if anyone can help me or even do it in database and upload it again.


best,
Khalil

Make a table,tQrys, w 2 columns, [caption],[qry]
The caption users will see, and the query to run.
Put in the queries of data to show,
Billing, qsBilling
Clients, qsClients
Etc

Make a form ,continuous form, or data sheet.
On the form header, put a combo box. This combo box reads tQrys.
The use can pick the qry to show on the form.
When user picks Billing, connect the form to qsBilling query.
Me.rowsource = cboQry

If you don't want do do this, then make 1 form for each query that is opened from a main menu. 1 form to show all billing records. 1 form to show all client records.
1 form to show the details of 1 client which also has a subForm to show the 1 client's billing data.