Not able to save Listview data on a access table

[jhargram]

Hi All,

I have some issue when i save list view data in a access table.
In form I have a list box(listtotalcount) and one text box(ID). In form load event I run a query on that list box like: "SELECT count(id) FROM table A" and it gave me the correct result. Now I want to store this data on a different table (table b) and I use this code:

Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("table b", dbOpenDynaset)
With rst
.AddNew
!id=txtid
!LineCount = listtotalcount


.Update
End With


But the problem is when I click the save button it store only id not the list box value. Can anyone update me the solution. Thanks in advance..

[June7]

Not saved because the listbox row needs to be selected to set the listbox value.

Use a textbox with DCount() expression in ControlSource: DCount("ID", "[Table A]").

Why would you store the count of all records in a table and associate to one ID?

Why even save record count? Surely this can be calculated whenever needed?