Can anyone please let me know if the following is possible and how to accomplish.
I have a form named WorkFlow which is my one stop form for the entire project. I want to be able to open this form and get all the data I need. To do this, I have a second form named TestResults. Upon completing the test we will be running, I want to be able to click a button, it open this form and if there is already a record in the TestResult tbl, open to that record, but if there is not a record for this test result, to automatically have the Property ID field entered to create a new record so we can enter the test results. Possible?