How do I write code to tell Access where to save a value? 1

[seawave]

I have a form with unbound objects and I do not know how to write the code to tell Access to save the value to the field in my table. Example: my user types a value of F0002 in the unbound textbox on the form. The field "CableName" is in my Cable Table. I want to save the F0002 value to the CableName field in the Table and then when the user completes the form, save the record and clear the values on the form for the next record entry.

Any help would be appreciate.

Thank you.

 

[PaulBricker]

Well if they are all unbound you can do this

Dim rst as DAO.Recordset
Dim frm as Form
Set frm = Forms!YourFormName
Set rst = CurrentDb.OpenRecordset("Cable Table",dbOpenDyanset)
rst.AddNew
rst!CableName = frm.textboxname
rst!NextField = frm.nextfield
rst!SomeOtherField = frm.someotherfield
rst.Update

frm.textboxname = Null
frm.nextfield = Null
frm.someotherfield = Null

set frm = Nothing
set rst = Nothing

Paul

 

[seawave]

Paul,
Thanks for the reply.
I entered my code, but I'm receiving an error message:
"Compile error User-defined type not defined".

Thanks.
Seawave