Default Value

  • Thread starter Thread starter Tom
  • Start date Start date
T

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")
 
Tom

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

What are you trying to accomplish (not "how", as you've described)?
 
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
 
Back
Top