default value (max from table) 1

[matrixindicator]

On my form I have a dropdownbox. The row source is a group by query of dates field. As default value the combobox should give the most recent date available (I created a query within it the max function on the date field).
Now I try to get this value as my default value. But this gives an error. #name ?

=[queryname].[maxdate]

syntax problem ?

 

[Remou]

You cannot refer to a query in that way. I seems that you need DMax:

[tt]=DMax("DateFieldName","TableName")[/tt]

You can use a Where statement with DMax, if you wish:

[tt]=DMax("DateFieldName","TableName","ID=" & [txtANumber] & " Company='" & [txtText] & "'")[/tt]

http://lessthandot.com

 

[matrixindicator]

your fantaxtic !