C Celtic Queen Registered User. Local time Today, 14:45 Joined Feb 26, 2003 Messages 29 Apr 3, 2003 #1 What do I type in a query's criteria when I want it to refer to a field in a child form,as opposed to a main form.Basically what do I refer to the field as?
What do I type in a query's criteria when I want it to refer to a field in a child form,as opposed to a main form.Basically what do I refer to the field as?
neileg AWF VIP Local time Today, 14:45 Joined Dec 4, 2002 Messages 5,975 Apr 3, 2003 #2 Example from Access help: curTotalAmount = Forms!Orders!OrderDetails.Form!TotalAmount