I am using access 2002. I have created a query and placed text boxes on a form. I have 3 text boxes that are for user input and i want to send the text from them to a new table when I click on a command button.

I have tried to connect using the following code but keep on getting errors:

Set db = OpenDatabase(App.Path & "\db3.mdb")
Set rs3 = db.OpenRecordset("log", dbOpenDynaset)

I imagine it has something to do with 2002 and would appreciate it if somebody could give me the correct code.

thanks in advance.