form field writing to more than 1 table

  • Thread starter Thread starter phuser
  • Start date Start date
P

phuser

I have a form where an amount must be entered can the amount be generated
in more than 1 table?
 
Yes.
Of course, you don't have to worry about the table the form is bound to.
Where you put the code to update the other table will depent on when you want
table2 updated. If it is only updated when a new record is created, then put
your code in the After Insert event of the form. If this is an amount that
may be changed from it's original value at some point after the record in
table2 has been created, then it should go in the After Update event of the
form.

Set rst = Currentdb.OpenRecordset("table2")
rst.FindFirst "[MyTableKey] = '" & Me.KeyID & "'"
If rst.NoMatch Then ' This is a new record
rst.AddNew
Else rst.Edit
rst!SomeField = Me.SomeTextBox
rst!Update
rst.Close
set rst = Nothing
 
Thanks!!

Klatuu said:
Yes.
Of course, you don't have to worry about the table the form is bound to.
Where you put the code to update the other table will depent on when you
want
table2 updated. If it is only updated when a new record is created, then
put
your code in the After Insert event of the form. If this is an amount
that
may be changed from it's original value at some point after the record in
table2 has been created, then it should go in the After Update event of
the
form.

Set rst = Currentdb.OpenRecordset("table2")
rst.FindFirst "[MyTableKey] = '" & Me.KeyID & "'"
If rst.NoMatch Then ' This is a new record
rst.AddNew
Else rst.Edit
rst!SomeField = Me.SomeTextBox
rst!Update
rst.Close
set rst = Nothing
phuser said:
I have a form where an amount must be entered can the amount be
generated
in more than 1 table?
Click to expand...
Click to expand...
 
Back
Top