Pulling multiple fields from a list box selection

[cstanley]

I have a list box that displays two fields from Table #1, and when selected, sends the value from one field (a text field) to Table #2. I would like it to send the value from a second field (a checkbox) to Table #2.

How do you do this?

Thanks,

Chris

 

[Travis]

You will need to reference the Column property of the selected Item and add update code to set the fields value.

You don't say how the first field from table #1 sets the corresponding field in table #2.

This type of code can be used on the AfterUpdate of the List Box Control.

 

[cstanley]

The field from table #1 and table #2 are the same - table #1 is a source table for values that are associated with other fields containing other values in table #2.

*said with an English accent* "Please sir, do you have a snippet of code you could give me?"

Thanks,

Chris

 

[Travis]

The Column property is Zero Based (First column = 0).


Put this on the AfterUpdate of the ListBoxControl.

me.[Table#2Field]=Me.[ListBoxControl].Column(1)