That sounds like exactly what I want! For some reason it doesn't seem
to be working, but it may simply be another part of the SQL statement
I'm working on.

Unless that doesn't work in SQL. _

On Jun 1, 5:13*pm, "Douglas J. Steele"
wrote:
Not really sure what it is you're trying to do.

To refer to the value in the first column of the currently selected row of
list box BoxA, you refer to Me!BoxA.Column(0) (or
Forms!NameOfForm!BoxA.Column(0))

To refer to the value in the second column of the currently selected row of
list box BoxA, you refer to Me!BoxA.Column(1) (or
Forms!NameOfForm!BoxA.Column(1))

--
Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)