Query to set text box

[Costefran]

Hello

Can anyone help with the following

I am trying to set the value of a text box on my form based on the result of a query
I usually create a subform based on the query and then set the text box on the form to the value in the subform on an after update event

So for example when I select a user name in a combo - box on my form it sets the phone number text box based on the value in the subform

This seems a long - winded way of doing this and I thought there may be an easier way

Note - the query always has only one result

Thanks

 

[PHV]

You may consider the DLookUp function

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Costefran]

Many thanks I'll give it a go