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

Thanks!

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...