Automating "Append" Query with Parameters

[Monterey_Manzer]

Hi Everyone,



I am curious if it is possible to use VBA code to pass parameters to an Append query. Basically I'm trying to build a dashboard type system by which my users could add new records based on a new set of parameters. The users would enter these parameters by use of Input Boxes. I haven't started researching this because I've got a few projects going on right now which is sucking up all my time but I'm curious if anyone can tell me whether or not this is indeed possible or would I be wasting my time playing around with this. I would appreciate any thoughts or speculations any of you may have.

Cheers!

[June7]

Yes, a simple example showing 3 field types (text, date, number):

CurrentDb.Execute "INSERT INTO tablename(fieldname1, fieldname2, fieldname3) VALUES('" & Me.textbox1 & "', #" & Me.textbox2 & "#, " & Me.textbox3 & ")"