I am a little confused... You say you want to add a NEW phone, but then say you want to copy an existing phone record data into the new phone record, but then want to put the details of the new phone into the record?
You have a form with controls for the phone details. (Not sure if the controls are bound or unbound.)
You just need to execute an append query to add the new phone to the table.
If the controls are unbound, you might use something like (**air code**):
Code:
Dim sSQL as String
sSQL = "INSERT INTO Devices (modelID, StateID, CustomerID, DevTypeID, PlansID,InUse , Notes)
sSQL = sSQL & " VALUES ('" & me.ModelID & "', '" & Me.StateID & "', " & Me.CustomerID & ", " & DevTypeID
sSQL = sSQL & ", '" & Me.PlansID & "', " & Me.InUse & ", '" & Me.Notes & "');"
' Debug.Print sSQL
Currentdb.Execute sSQL, dbfailonerror
I'm not sure which fields are what type, so some of the delimiters may be wrong.