Default Value

[Tom]

How can I modify the default value string below so that I can sort in ASC
order?

Properties "Default Value" (unbound field):

=DLookUp("[IDNo]","tblPayees")

 

[Jeff Boyce]

Tom

Consider using a query as a source instead of DLookup().

What are you trying to accomplish (not "how", as you've described)?

 

[ChrisJ]

First of all, DLookup returns a single value, not a
recorset or list

If the "Where" clause of the DLookup is missing, as in
this case, the function will return the first value it
finds.

To specify a single particular value, include a "Where"
statement that specifies a unique row

DLookUp("[IDNo]","tblPayees", "[IDNo] = 1234")

or consider using the DMax function instead