Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 15th, 2004, 04:42 PM
Authorized User
Join Date: Nov 2003
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lookup Table Problem

I am having a problem with the boundcolumn control on a lookup table. The field is looking up values in a query and I am trying to get the field to store the value in the second field. I have used the wizard and also set it up manually and set my boundcolumn control to 2, but it keeps giving me the value in the first field.

I know that the solution is simple and I am overlooking something, any help would be appreciated.

Old January 15th, 2004, 05:08 PM
Authorized User
Join Date: Dec 2003
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts

Check the field property for number of columns...be sure it is set to 2...then set the bound column to 2.

Let me know how you make out. (Also, any values previously stored will remain there...they will not automatically refresh to the value in the second column...the setting will only apply prospectively)

Old January 19th, 2004, 07:11 PM
Authorized User
Join Date: Oct 2003
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts

jrwlkn is correct, but just because coloumn 1 is the "seen" column, doesn't mean it's the "bound column.
If you put column 2 as the bound column, I can't see any reason under the \sun why it wouldn't be.
Column widths property allows you to control which columns are seen irrespective of the bound column.
(I might be taken it for granted that you actually tried it as a link, to see which column is bound. your table results will show which column is bound also...?
but as jrwlkn said, your number of columns have to be at least the number of your bound column.
Please excuse any elementary pointers here.

Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup value in table Vince_421 Access 16 February 13th, 2007 08:15 AM
Retrieve info about Lookup RowSource for a table c Proteus_3k Pro VB Databases 0 December 2nd, 2004 07:05 AM
Lookup (Dispatch) Table CNewbie C++ Programming 5 November 2nd, 2004 04:12 PM
lookup table current field. Squid Access 0 December 21st, 2003 07:08 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.