Search results

OK, I see it now. Thanks that had me stumped.

I am trying to learn Access. I often refer to The Northwinds sample database to figure stuff out, but something has me perplexed. When you view the "Orders Qry" query it has an employee field and it displays their full name. When you view it in design mode that same column is actually...

Thanks for the reply. I've done what you said, and my code now reads: stLinkCriteria = "[ProductID]=" & "'" & Me![ProductID] & "'" & "'" And [PONumber] = "'" & "'" & Me.Parent![PONumber] & "'" Now I get the following error: "Microsoft Access can't find the field "|" referred to in your...

I have a form with a subform. The main form has Customer, PONumber, and OrderDate fields. The subform contains ProductID, QtyOrdered, QtyProduced, and QtyRemaning fields. I also have a third form that I want to open and filter when I double click the ProductID field in the subform. I've got...