.update field of other table

[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?

 

[Steve Schapel]

Mark,

My answer in the earlier thread!