Updating two fields on Command ADD

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All, I currently have a form that on Click of a command button, updates a
field for me, using the following OnClick code:

Private Sub Add_New_Case_Click()
DoCmd.GoToRecord , , acNewRec
Me.MISLE_Number.SetFocus
Exit_Add_New_Case_Click:
Exit Sub
End Sub

It works great, however I now need to update TWO numbers with the same
click, is this possible?

My table of record is tblSENESarLog2008, and my primary field to update (the
one I always had) is in that table. The new field I want to update is a
concurrent number and lives in tblSENEIncidentLog2008.

Thanks in advance,
Steph
 
Hi All, ever mind, I figured it out. I was using poor design, there was no
need for 2 tables.

Thanks anyways!
 
Scuda,
I don't see where the field update is happening.
I see you are creating a new record and setting the focus to a control, but
I don't see anything that populates a control. Is it possible the control
you thing you are populating has a default value?
 
Back
Top