Ribbon looks for record with current username

[Superguppie]

hey there,

in the ribbon i want to have a text that says: Name of Username, you have ** task open.

the ribbon must look to the current username (stored in a variable) and then look to the query and look if the name is there, and then show to the user howmany records with his name are in the query.

so, if user Jan, has 2 tasks in the query, and user Klaas has 7 tasks in the query (same query) then if Jan logins then the ribbon must say Jan, You have 2 tasks open. When Klaas logins, then it must say: Klaas, You have 7 tasks open.

How is this done?

Many thanks in advance

Greetz
Superguppie

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886