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

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

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box 2
Using a Query parameter in an "In()"-Clause 4
Access 2000 append unbound text box values to a table 0
Multi Field search Form 2
using office and access to create a mail list 7
ListObjects.Add Question 3
How to Return the value of field from two lookup? 1
showing just the latest value in a text box 3

Back
Top