insert into a table from

hello



thank you for the answer

i also wrote the below code but i have error in below line

i don't know what to write instead of that

can you help me please?



Dim db As Database

Dim rec As Recordset

Set db = CurrentDb

Set rec = db.OpenRecordset("Select * from tbl_userinformation")

rec.AddNew

rec("Anwendung") = Me.Label135.Caption

rec("actualdate") = !Forms!frm_main!Text0.Value



rec.Update

Set rec = Nothing

Set db = Nothing



i have the following error



invalid or unqualified refrence



can you help me please?

thank you

insert into a table from