Default Value in a field based on a query

[jonesda]

Hi,

I have a query which returns 1 value (The description associated with the maximum ID in the table).

I have a Text box on a form and I would like the default value of the text box to be the the value from the above query.

I have tried to build an expression using the expression builder by selecting the query and the field that I am interested in, in that query but I can't seem to get it working.

Could anyone please advise how I can assign a result from a query to the default value of a field on a form.

Many Thanks

 

[FoFa]

You can use DLOOKUP to return the value of the query. You can use it in the DEFAULT value. I would however check to see if there is an agregate function that you can use to replace your whole query however, like DMAX may be your ticket.