Default value of value list

[load3d]

I have a drop down list that displays only one value when the query runs. The value is populated when the user enters the equipment number into a form field. A SQL statment is kicked off to populate the drop down list (only one row/value is returned) for example:

A user enters. MHE-123 (as the equipment#)

the SQL query returns one record

How do I make that record my default value?

or better yet... is it possible to set the value of a text field using a SQL statement and without using a value list box?

 

[Remou]

You should be able to use DLookUp.

 

[load3d]

Pass. Thanks. Can't believe I couldn't get that.