I have a Combobox table lookup query that works when I look at "FormA". The Combo box is on a subform of Form A. SELECT Classes.ClassCode FROM Classes WHERE ((Classes.EvCode)=Forms!FormA!EvCode) ORDER BY Classes.ClassCode; When I then make Form A a subform of the Main form, the above query no longer works. MainForm FormA SubForm I am not using a situation where there are two subforms of a main form, which would look like: MainForm Subform1 Subform2 I never want to just look at FormA by itself. It should always be a subform of the main form. I just noticed that it worked when it wasn't a subform. How should I change the query to work when FormA is a subform.