setting textbox value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason I'm having troubles changing the text value of a textbox. What I'm doing is running a query and trying to set the control source of the textbox equal to the results that come back from this query. So the control source looks something like the following

=SUM([SubForm].Form![IN])-SUM([SubForm].Form![OUT]

So on the form I have two selections that are made by the user using ddls. The user clicks a button and the query is executed, displaying the results in a subform (SubForm). The textbox I want to use to display the balance in on the main form. I've tried doing requery on the textbox after each submittal by the user, but I still cannot get it to populate the textbox with the control source i have above

I know this is pretty vague, but do you have any ideas? On a side note, can you recommend a good online source for learning access programming

Thanks!
 
On my website (see sig below), is a small sample database called
"SubformReference.mdb" which illustrates who to do reference objects on
subforms and subsubforms. It might give you some ideas.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

tbox said:
For some reason I'm having troubles changing the text value of a textbox.
Click to expand...
What I'm doing is running a query and trying to set the control source of
the textbox equal to the results that come back from this query. So the
control source looks something like the following:
=SUM([SubForm].Form![IN])-SUM([SubForm].Form![OUT] )

So on the form I have two selections that are made by the user using ddls.
Click to expand...
The user clicks a button and the query is executed, displaying the results
in a subform (SubForm). The textbox I want to use to display the balance in
on the main form. I've tried doing requery on the textbox after each
submittal by the user, but I still cannot get it to populate the textbox
with the control source i have above?
I know this is pretty vague, but do you have any ideas? On a side note,
Click to expand...
can you recommend a good online source for learning access programming?
 
Back
Top