How do I place the return value from a querey into a text box cont

[Guest]

New to Access, I want to post the result of a querey onto a control on a form

A is it possible?

2 How is it done?

thanks

 

[Carl Rapson]

New to Access, I want to post the result of a querey onto a control on a
form

A is it possible?

2 How is it done?

thanks

It can be done if the query returns a single value. There are actually two
ways you could do it:

1. Open a recordset using the query, and copy the value from the recordset
to the control.
2. Use the DLookUp method to populate the control.

Carl Rapson