Querry result to form field?

  • Thread starter Thread starter Jason Rhymes
  • Start date Start date
J

Jason Rhymes

I have a query calculator I've made (attached sql) to calc. cost per foot.
Everything works correctly in the query even though it's probably not the
best way of doing it. How do I get the results to a form field?
 
Hi, Jason.

On the contrary, you are doing it precisely right. Allen
Browne, MVP, recently posted a link to his webpage which
explains why:

http://members.iinet.net.au/~allenbrowne/casu-14.html

However, you have a fundamental understanding. Forms do
not have "fields", they have "controls" whose Control
Source may be set to a field in the form's underlying
table, a calculation, a value returned from a function, a
constant, etc.

To display a calculated field is no different than
displaying a table field, simply set the text box' Control
Source to the name of the calculated field in the form's
underlying query.

HTH
Kevin Sprinkel
 
Back
Top