I am writing a db to analyse our company's itemised billing for mobiles and I want to provide a flexible search on period (i.e. month, not between dates), user (or number) and call type.

I have created Value Lists of these and defined Global Vars which display as Checkboxes of the lists. So idea is create find, select one or more month periods, one or more users and one or more Call types then execute the search.

However, as there are quite a few users I wanted to be able to set the global var for users, say, to everyone. But I cannot find a way to SetField g_Users to the contents of Value List "Users".

Any ideas? Or am I making this difficult for myself?

TIA

Craig

Edited November 13, 200916 yr by Guest

I am also looking for the same solution

Ken

SysAdmin

I think I found it, at least for my purposes - it's

the function ValueListItems(FileName;valueListName)

Ken

SysAdmin