<div>
What is he need for this?<br />
<br />
I mean, ...there is a way to do this as you ask, ...<br />
<br />
But if you state your ultimate goal, we may be able to provide a more efficient method...<br />
<br />
For example, it should be far easier to insert the listbox &quot;source&quot; to a table.<br />
<br />
But again, if the listbox source is already a table/query, ...what is the need to export it to another table?<br />
<br />
JeffCoachman
</div>


What is he need for this?

I mean, ...there is a way to do this as you ask, ...

But if you state your ultimate goal, we may be able to provide a more efficient method...

For example, it should be far easier to insert the listbox "source" to a table.

But again, if the listbox source is already a table/query, ...what is the need to export it to another table?

JeffCoachman

<div>
<div class="content wysiwyg-content">
I'm trying to write values from a listbox to an unbound table.<br />
<br />
My code isn't working.<br />
<br />
Here it is:<br />
<br />
&nbsp; &nbsp; Dim RS As DAO.Recordset<br />
&nbsp; &nbsp; &nbsp; &nbsp; Set RS = CurrentDb.OpenRecordset(&quot;t<wbr />blReady&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS.AddNew<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS!Bay = Forms!frmPlanted.ListBayQt<wbr />y.Bay<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS!ReadyQty = Forms!frmPlanted.ListBayQt<wbr />y.ReadyQty<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RS.Update<br />
<br />
????
</div>
</div>


I'm trying to write values from a listbox to an unbound table.

My code isn't working.

Here it is:

    Dim RS As DAO.Recordset
        Set RS = CurrentDb.OpenRecordset("tblReady")
            RS.AddNew
            RS!Bay = Forms!frmPlanted.ListBayQty.Bay
            RS!ReadyQty = Forms!frmPlanted.ListBayQty.ReadyQty
            RS.Update

????

Trying to write values from a listbox to an unbound table

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.