I have database with many tables. In the first table, I have a field called
table 1 idno name status 111 hjghf yes 225 hjgjj no 345 hgj yes
Other tables could have same
idno with different fields.
I want to check the status for each id no and if it is yes then for that id number in all tables for all null and blank fields I want to update them as 111111.
I am looking for a sample vba code for this which I can adapt.
Here is some largely untested code. Hopefully it will give you a start.