[AccessD] Dlookup - where parameter being a form control vs a function

[Borge Hansen]

Gustav,
Thanks, of course ... single quotes!

?DLookup("NextAvailableUFN", "tblSystem", "UserName =
fGetApplicationParameter('CurrentLoggedInUser')")
 900005
?DLookup("NextAvailableUFN", "tblSystem", "UserName = '" &
fGetApplicationParameter("CurrentLoggedInUser") & "'")
 900005

Zzzzzz...
/borge

On Thu, May 20, 2021 at 5:44 PM Gustav Brock via AccessD
<accessd at databaseadvisors.com> wrote:
>
> Hi Børge
>
> I'm not sure what your question is, but this could be written as:
>
> ? DLookup("NextAvailableUFN", "tblSystem", "UserName =  fGetApplicationParameter('CurrentLoggedInUser')")
>
> /gustav
>