Recent content by dwrobins

Thank you for the quick response. Newer to VBA so not really following. I have attached the screen shot above. I have a text field called open labor which retrieves the record ID I want the subform to navigate to . I can get the value passed down to text 12(103 in this example)...

I have a main form called scanningdetails and a subform called labortrackingtablesubform. When scanning a field in the main form I pass a value to a field [text12] in the subform. I then run this code on the field text12. the code works when I open the subform by itself but not when...