I have a table displayed in a continuous SUBform. I want to append the records that have a value in Field_A to an existing table (tblBundles) so some of the records will not be appended (no value in Field_A).
Of the records that are appended some wiil have Null in two fields Field_B and Field_C. I need to replace the Nulls with the next value (datatype is text) that appears in the field. There could be one record or several with Nulls before there is a value in the fields again. All records with Null in these fields should be "updated" with the next value appearing.
How do I do this in code.
I suppose the Null fields could be completed in an array before appending the records?
Thanks in advance for any help.
Of the records that are appended some wiil have Null in two fields Field_B and Field_C. I need to replace the Nulls with the next value (datatype is text) that appears in the field. There could be one record or several with Nulls before there is a value in the fields again. All records with Null in these fields should be "updated" with the next value appearing.
How do I do this in code.
I suppose the Null fields could be completed in an array before appending the records?
Thanks in advance for any help.
