|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 1st, 2004, 01:51 AM
|
|||
|
|||
Default Value
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") -- Thanks, Tom 
|
|
#2
June 1st, 2004, 02:06 PM
|
|||
|
|||
|
Default Value
Tom
Consider using a query as a source instead of DLookup(). What are you trying to accomplish (not "how", as you've described)? -- More info, please ... Jeff Boyce Access MVP
|
|
#3
June 2nd, 2004, 01:15 AM
|
|||
|
|||
|
Default Value
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 -----Original Message----- 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") -- Thanks, Tom .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
