<div>
I think you can just set the control source of your listbox to your &quot;book&quot; field.
</div>


I think you can just set the control source of your listbox to your "book" field.

<div>
sorry I missed type the data is from a query the control source is the book field.<br />
the problem is it writes from the id &nbsp;column &nbsp;instead of column 2. ( it writes the id instead of the bookid)
</div>


sorry I missed type the data is from a query the control source is the book field.
the problem is it writes from the id  column  instead of column 2. ( it writes the id instead of the bookid)

<div>
Well, if you have the listbox control source set to your book field, and your bound column is the bookid column, it should work fine. I would just make sure you have your columns in the order you think they are, and you are binding to the correct column.
</div>


Well, if you have the listbox control source set to your book field, and your bound column is the bookid column, it should work fine. I would just make sure you have your columns in the order you think they are, and you are binding to the correct column.

<div>
yes I have it set correctly but it still writes the ID value in the book field.
</div>


yes I have it set correctly but it still writes the ID value in the book field.

<div>
Could you possibly attach the database or a sample of it so I can take a look?
</div>


Could you possibly attach the database or a sample of it so I can take a look?

<div>
<div class="content wysiwyg-content">
I have a form with &nbsp;a list box with 3 columns<br />
1 ID<br />
2 bookid<br />
3 title<br />
The form control source is catalog<br />
The list box control source is query from another table called library.<br />
When user selects bookid (column2)<br />
I want to write column 2 value to field book to table catalog.<br />
I have my list box as 3 column count and bound column 2 .<br />
<br />
Thanks
</div>
</div>


I have a form with  a list box with 3 columns
1 ID
2 bookid
3 title
The form control source is catalog
The list box control source is query from another table called library.
When user selects bookid (column2)
I want to write column 2 value to field book to table catalog.
I have my list box as 3 column count and bound column 2 .

Thanks

Writing unbound colum to text field from list box

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.