Bind Columns (Fields)

[junimation]

I have been looking on the forum for some code that would bind all columns (fields) starting from column 15 to 26 to a combo box



for example....



Field 1 Field 2 Field 3 Field 4

data1 data2 data3 nodata



Combobox

data 1

data 2

data 3





kind of like a grid

based on the record I select in my form the combo box will show the columns that have data for that record.



It is trycky but I have no idea how to get that started





Thank you all for your help

 

[The_Doc_Man]

This forum's search function works well. Look up topic "Cascading Combo Boxes" to see some discussions on this subject.

 

[junimation]

thnak you will do that

 

[Pat Hartman]

When you want to show multiple columns from a lookup table, use a query that joins the main table to the lookup table as the RecordSource for your form/report. When you choose the "linking" field from a combo or type it in, the lookup fields are automatically populated. Make sure to set the locked property of these fields to Yes to prevent accidental updates.

You can see an example of how this works in http://www.access-programmers.co.uk/forums/showthread.php?p=293920#post293920

 

[junimation]

Thanks for your help I'll look into that as well.