Query in text or combo box

[Guest]

How to display query result in text or combo box as default value?
Thanks!

 

[Guest]

You can use a domain aggregate function such as:
=Dlookup("[YourField',"YourQueryName")

 

[Guest]

You would not use a query for the default vaule.
Use a DLookup function.