How do you assign a listbox column to a text box....

[Pack10]

I have a listbox that contains 4 columns.
I would like to assign column 3 and column 4 of the listbox
to two text boxes on the form. I forget the syntax.

 

[randy700]

Something like this? Column numbering begins with 0.

=Me.ListboxName.Column(2)
=Me.ListboxName.Column(3)

Randy

 

[Pack10]

Seems logical but its showing as null

 

[randy700]

Sorry.
Replace Me! with Forms!yourFormName


Randy

 

[dhookom]

If the controls share the same form then try:

=ListboxName.Column(2)
=ListboxName.Column(3)

Duane
Hook'D on Access
MS Access MVP