I need help on something that is beyond my Ms access knowledge. I have two tables; one is a Sampletbl and the other is a Test Resultstbl. The tables are one-to-one via SampleID. When I am on my Sample Form, I would like to click a button that moves me to my Test Results form to enter the results for the sample. These results would be for the current record I was on in my Sample form. I have tried to achieve this via macro but it's not working.