View Single Post
  #1  
Old June 1st, 2010, 04:02 PM posted to microsoft.public.access.forms
Lawrence Chu
external usenet poster
 
Posts: 4
Default Using the second column of a lookup field in row source

I'm working on a form on a database in which I need to do a lookup on
one combo box that contains two columns, and a followup combo box
requires that I match something in the second column. So, basically,
if I have Box A, which looks up a BoxA_ID column (column 1) and a
BoxA_Value (column 2) column, I'd like to create a statement in Box B
where I'm trying to match a value with the BoxA_Value column.

Can anyone help me here?