I have an update query set up like this
Table A = Table to be updated
Table B = Table to be used as the source table to update table A
I am wanting to use Table B as sort of an Autofill table. The user would enter values into the fields in Table B. After running the update query, all fields in Table A would be updated to the values in Table B.
So far it works and updates all fields as intended. This is to update mass amounts of records which need the same data in those fields. My issue is that say I only want to update field1 in Table A. If I only enter a value in field1 of Table B, then the update query will update not just that field, but it will also update all values in all the other fields as blank. How can I prevent this from overwriting those other fields? If I put a criteria that the source field be "is not null" it wont run any update if even one field is left blank in Table B.
Im comfortable working with VBA but im not sure how I to even start for this kinda of update.
Id appreciate any help!
-Mario