Access - Form list Box data to table

[DenamP]

Hi everyone,

I have a form in my database with a list box. The list box values come from a separate table created just to store values for the list box.
What I want to happen is for the value that a user selects from the list box (in the form) to appear exactly as it is in the main table the form is being used to enter data into.
This is working, but the text values in the list box are being entered into the main table as numbers. For example, selecting the first text value in the list box would produce a value of '1' in the main table.
How do I get it to display the actual text value instead?

Thanks!

[Mihail]

The value entered in your TextBox is the value for FIRST column in your ListBox (I think here are the IDs for ListBox items and this field is hide in the ListBox.

Use
TextBox = ListBox.Columns(n)

where "n" is the number of column in your table (and in ListBox too). "n" for first column is zero.

Good luck !

[DenamP]

Thanks Mihail. I am afraid I am a bit rusty with Access, where do I enter
"TextBox"=[ListBox].[Columns]("9")?

Thanks!

[Mihail]

TextBoxName = ListBoxName.Columns(9)
Without quotes because the .Columns argument is a number, not a string.

[Mihail]

DenamP !
Sorry for my misunderstood. There are 2 ways to solve that (at least).

One is to set the TextBox control source in the Property Sheet pane:

=[ListBoxName].[Column](9)

The second is to use the Click event for your list box:

Private Sub ListBoxName_Click()
    TextBoxName = ListBoxName.Column(9)
End Sub

I always prefer the VB solution because the flexibility.