.update field of other table

  • Thread starter Thread starter Mark R
  • Start date Start date
M

Mark R

I messed up my reply thread by accidentally hitting tab
and I don't see a response, so here it is again.
Anyways, here's the question:

By making a combobox unbound on the Main form, and then
using a VBA procedure on its After Update event, I
can "put" data into a subform record. The forms both have
the same autoID key, and the subform cycles ID to ID with
the main form.


Combobox_Afterupdate()

Set rs = NotMainTableName.recordsetclone

With rs
.Find "ID = " & Me.ID
.Edit
NotMainTableName!insdatafieldname = unbounddataheld
.Update
End With

=============
This is a skeleton of VBA code, but specifically what do
I have to code to make it work?
 
Back
Top