Richard: The boundcolumn is set to 2 which is the pk. It is returning the record number of the select statement and no the pk of the table - which is what I would expect.
Thanks, Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com On 09/02/2011 07:08 AM, Richard Kaye wrote: > Set the BoundColumn property to your pkey. > > -- > rk > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Jeff Johnson > Sent: Friday, September 02, 2011 9:57 AM > To: [email protected] > Subject: Primary Keys in SELECT Statement > > Forgive me if this has been asked before. I looked for it but couldn't > find it. I am using an array as a row source in a list box. When I do > a SELECT f1, pk FROM mytable INTO myarray ORDER by f1 the pk value is the > record number from the select statement and not the pk of mytable. > The control source is bound to the pk so when I put pk in the control source > it points to the wrong record. > > I've worked around this by using another field in the table to identify the > record, but it would be preferred using the pk. > > -- > Jeff > > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
