G
Guest
I have a table that has four columns. This table is the result of certain
actions a person takes to need additional training. The four columns are
Name, SSAN, Date, and Reason.
I have several different queries, I'm planning on each one to develop it's
own reason (i.e. reason 1 = A, reason 2 = B, etc). I have this code to update
the SSAN:
Dim MyDb As DAO.Database, MyRec As DAO.Recordset
Set MyDb = CurrentDb
Set MyRec = MyDb.OpenRecordset("Select [SSAN] From
[T-NCMR]")
MyRec.AddNew
MyRec!SSAN = Me.Ctl60_Day_SSAN
MyRec.Update
But I can't figure out how to update everything else without creating
different rows. I appreciate any help I can get with this.
John
actions a person takes to need additional training. The four columns are
Name, SSAN, Date, and Reason.
I have several different queries, I'm planning on each one to develop it's
own reason (i.e. reason 1 = A, reason 2 = B, etc). I have this code to update
the SSAN:
Dim MyDb As DAO.Database, MyRec As DAO.Recordset
Set MyDb = CurrentDb
Set MyRec = MyDb.OpenRecordset("Select [SSAN] From
[T-NCMR]")
MyRec.AddNew
MyRec!SSAN = Me.Ctl60_Day_SSAN
MyRec.Update
But I can't figure out how to update everything else without creating
different rows. I appreciate any help I can get with this.
John