I changed my mind...

On form called “Fitness”; I want the user to click on a command button that will display Last Name; First Name; Key Number from a form call Profile in the same db.

After they select the correct name; populate the same fields (Last Name, First Name; Key Number) on this form (Fitness)

Quote:


No, because I thought I needed to look at the @xlookupsourceListAll to create a multi column picklist.

I haven't gotten past this...using an example from pg 92 of the book.  It returns nothing. 

(On element entry of command button)

var MyStr as String
     
MyStr = @XLookupSourceListAll(@FN, "..", "Profile!LNAME", "LNAME;First Name;Key Number5")

WriteLN(MyStr)

I wish I could work with Sesame all the time.  Only doing this once in a blue moon makes it hard to retain.  Plus I get confused with Access/Excel Programming.

Anyway...THANK YOU....Thanks to your guidance I got the picklist to popup from command button; now I'll need to figure out how to populate this form with their choice.  But my first attempt below populates the each form elements with the first 3 records (Last Name * First Name * Key Number5 in each field) not parsed out.  So how do I parse the field back out.

var MyStr as String
var VLName as String

    
MyStr = @XLookupSourceListall(@fn, "..", "Profile!Last Name", "Last Name;First  Name;Key Number5")

MyStr = @replace(MyStr, ";", " " + @chr(149) + " ")

MyStr = @replace(MyStr, @Chr(10), ";")

vLName = @PopupMenu(MyStr,"Select one of these Employees")

Last Name = @AccessStringArray(myStr, 1)
First  Name = @AccessStringArray(myStr, 2)
Key Number5 = @AccessStringArray(myStr, 3)
 

FOUND IT:

MyStr = @Replace(MyStr, " " + @chr(149) + " ", ";")

yes!!!!