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

J

Jr@worldswonder

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
 
C

Carl Rapson

Jr@worldswonder said:
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
Click to expand...

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
 
Top