B
Bob Richardson
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.
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.