How to add the result of a query to a form?

[dniezby]

I'm designing a form to input data (I know shocking right). I have a DOB field in my table. When I enter the DOB I want the persons current age to pop up on the form.



I prepared a query that does this but how do I get this to show up on the form?

[pbaldy]

I wouldn't bother with a query. Whatever formula you used can be the control source of a textbox:

=YourFormulaHere

[dniezby]

Thanks. That worked out. That's great for things that just need to show up on the screen.

[pbaldy]

No problemo.