Placing result of query in text box on form.

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

Guest

Hi,

A simple one (I think).

How do I get the results of a query to be placed in a text box on a form.
The Text Box is called 'Txt_Color' and the query is called qry_colors with
one field 'color'.

I will place the code in the on_load property.
 
assuming that you want to display data from only one record in the query,
you can use a DLookup() function to return the value you want from the field
in the query. either set criteria in the query so it returns only one
record, or set criteria in the function so that it finds a specific record
to return the value from. if you've never used the DLookup() function,
recommend that you read up on it in Access Help so you'll understand how it
works.

hth
 

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

set text box value to result of query 2
Setting the value in a text based on a query result 3
Query by Form 1
Retrieve the Control Source of a Text box in an Acess form 3
#error in text box 3
Visual basic code of combo box used for parameter query 1
Hello happy new year to all, Text box input for year of purchase 0
Form not working 2

Back
Top