I am working on improving an independent subform so that I do not have
to put any code on the main forms it is being used on.
Jon and Salad just helped me figure out that I can trigger code on
changes to the links based on the subform's "OnCurrent" event.
However, I now have a new problem. When the value I am linking with my
master/child fields does not exist in my Subform's table, I need to use
the value in the master field.
I have tried googling yet again, and cannot find an answer. Lots and
lots of pages on setting which fields are linked. But, not on pulling
out the values being passed in.
me.linkmasterfields.value does not seem to work
me.linkmasterfields.value(0) does not either.
me.recordsource only gives me the name of the table.
me.recordsourcequalifier gives an error.
me.parent.[myfieldname] works. But, I am not sure the field name is
the same everywhere.
Anyone know if it is possible to have the subform address exactly what
value is being passed for a given "linkmasterfields" column?