PersonXGroupSubformQ issue - Microsoft Access Association Database, Part 11


	Back to Association 11 Comments List

Upload Images Link Email

PersonXGroupSubformQ issue

Sarah Davis

2 years ago

Hey Richard! I've been working through the Association DB Fast Tips and ran into a problem in Association 11 with the PersonXGroupSubformQ. My subform works fine until I enter the criteria for GroupTypeID. When I enter Forms!PersonF!SubformControl.Form!GroupTypeCombo and then open PersonF and click on the Groups label I get a parameter dialog box asking for a value. When I enter either Family, Club, Company, or Interest, the PersonXGroupF subform does not display at all. All I see is a white box where the subform should be. Thanks!

	Kevin Robertson 2 years ago
It may be a spelling mistake. What value is the parameter dialog asking for? Some screenshots may help us to troubleshoot the problem.

	Sarah Davis OP 2 years ago
I figured out what the problem was. I named my subform control differently than Richard did. My subform control is named ctlSubform and when I was writing the code I kept entering SubformControl.Form instead of what ctlSubform.Form. I finally stopped getting the parameter dialog when I entered the requery commands in the code editor.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Association 11.