Hello, it's been a while since I've been here. All the help I received before kept me from having to come back.
I have two tables Lead tbl and Asbestos tbl
I have a form to input the information.
Right now I am set up like this. I have tried it every way I can think of.
I put the first record set in and it works great. When I try to input the 2nd record in my form, I get this.
Asset ID is a unique number in both tables. I am trying to input into both tables (and report) based on the Asset ID. What am I doing wrong?
The frustrating thing is I've done it before, I'm just so old I can't remember how.