A
Alex
I have a form frmParts with record source tblParts. In frmParts, I'm using
the macro action setvalue to set the value of many fields in my form, which
are then stored in tblParts. The setvalues expression is a dlookup looking at
fields in other tables in my database, tblA and tblB, which I haven't been
able to successful relate with tblParts.
My question is: tblA and tblB are often updated through importing. I'm
doing the import and update tblA and tblB in VBA. Is there a way, in VBA
where, after I import a new tblA or tblB, that I can run through all the
records in my tblParts and update the fields that were originally populated
using the macro action setvalue when the form/record was open? Thank you
very much.
the macro action setvalue to set the value of many fields in my form, which
are then stored in tblParts. The setvalues expression is a dlookup looking at
fields in other tables in my database, tblA and tblB, which I haven't been
able to successful relate with tblParts.
My question is: tblA and tblB are often updated through importing. I'm
doing the import and update tblA and tblB in VBA. Is there a way, in VBA
where, after I import a new tblA or tblB, that I can run through all the
records in my tblParts and update the fields that were originally populated
using the macro action setvalue when the form/record was open? Thank you
very much.