Have two forms with separate tables behind each. have code that will take unique id from Form1/Table1 check to see if there is a like number on form2/table2 and if not add a new record. the problem is that when the code runs I have one more record showing on form2/table 2 nav buttons then what is on form1/table1 even though the id's match.
How do I get everything to match
How do I get everything to match