I would like to use the following sub routine to take data from a field on a form and pass the data to the table:
Public Sub VGTruck(Driver1_FName As String, Driver1_LName As String)
CurrentDb.Execute "INSERT INTO VGTruckProcessing (Driver1_FName, Driver1_LName) Values ('" & Driver1_FName & "','" & Driver1_LName & " ')"
This is on my form that I want to pass the data to
trkproc.VGTruck (me.Name1 , me.Name2)
I want the data from the control, I tried using "Driver1_FName as Control" but that is wrong too. Don't know what I should use here.
but changed to this...and works perfectly.