In my application I am using 3 forms. Form1 is based on 2 tables, the primary key is LAB_NO. Form2 and Form3 are both base on sub forms which display data from 4 tables based on LAB_NO. My problem is this, I want to return to Form1 on the same LAB_NO I was on when I left. Currently I am using the folowing code:
stLinkCriteria = "[LAB_NO]=" & "'" & Me![LAB_NO] & "'"
This work but set a filter, which means I can't move to next or previous record without resetting the filter. When I do it returns to record 1. I've tried several things and I can't get it to work.
Any suggestions???
stLinkCriteria = "[LAB_NO]=" & "'" & Me![LAB_NO] & "'"
This work but set a filter, which means I can't move to next or previous record without resetting the filter. When I do it returns to record 1. I've tried several things and I can't get it to work.
Any suggestions???