View Single Post
  #6  
Old June 2nd, 2010, 07:45 AM 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

All right, I'll see if I can manage that.

Thanks!

On Jun 1, 7:53*pm, "Douglas J. Steele"
wrote:

No, I don't believe you can refer to the Column collection in a SQL
statement.

One approach would be to create a function that returns the value.