Placing result of query in text box on form.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew - 30 Dec 2006 05:33 GMT

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.

Signature

Andrew

Reply to this Message

tina - 30 Dec 2006 06:04 GMT

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

> Hi,
>
[quoted text clipped - 5 lines]
>
> I will place the code in the on_load property.

Reply to this Message