Finds "NOT in column" values and prompt user do add

[mfaqueiroz]

Hi, everyone

I'm doing one form that compares two columns of different tables, the Table A and the Table B, if there is one value of table A that don't match with table B , access opens one box where user can write the new value and it is automatically added to Table B.

Well..do you have any suggestion?

I really appreciate your help

 

[spikepl]

Suggestion for what? It is not clear what you are stuck on or need fixed.