lone textbox control source

[JaredTaylor74]

I have a table called tblMain in which there are several different clients and an amount field, among others...

I have a form using tblMain, with a sub form using different filters. (depending on which button the user selects on the parent form, they can see different dat ranges)
there are text boxes on the main form the user can use to add data to tblMain.

I have a text box (txtTotalBalance) that I would like to show the total balance, for that client no matter what date range they select using the amount field.
can't i have an unbound txtbox using it's own control source (in code) even though the form is bound?
i'm trying to have its control source = a select statement that

am i doing this right?

 

[mph1]

There is no reason that I know of as to why you can't have an unbound text box in a bound form.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[PHV]

Take a look at the DSum function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244