How to bind unbound data to table

[David Randle]

Hi

I would like to know how to populate a table field with unbound data from a form.

Thank you



David

[orange]

What have you tried?

Readers need more info re your situation. Why not use bound form?

[NTC]

one has no choice but to write into the table via an append query or update query....

[David Randle]

Thanks

I fixed this using

With rst
.AddNew
!ProductId = Me!TxtID
!ProductDescription = Me!TxtProductDescription
!TransDate = Me!TransDate
!InorOut = Me!Frame27
!Quantity = Me!txtQuantity
!UnitCost = Me!UnitCost
!GST = Me!GST
!TotalCost = Me!TotalCost
.Update
End With
rst.Close