I have created one table of cadets with typical things such as Last Name, First Name, etc. One of my fields is named Platoon with a data type as Text for data input as 1,2,3...etc. Since there will be no "computation" on this field, I felt it would be better to define it as Text rather than an Integer.
I then developed a parameter query for the user to be prompted to enter which platoon members they wanted to view. This was successful in "filtering" the records to one specific platoon at a time.
I then developed a form based upon the Platoon query. Everything was going "to plan" until I thought it'd be nice to have a combo box for Lastname. The Combo Box should only contain those last names associated with the already determined platoon. But I can't seem to get this to work correctly. I seem to be able only to get a Combo Box with ALL Last Names listed (which sort of defeats the purpose of the parameter query, in my humble opinion).
Could anyone point out the error of my ways?
Thanks
S
I then developed a parameter query for the user to be prompted to enter which platoon members they wanted to view. This was successful in "filtering" the records to one specific platoon at a time.
I then developed a form based upon the Platoon query. Everything was going "to plan" until I thought it'd be nice to have a combo box for Lastname. The Combo Box should only contain those last names associated with the already determined platoon. But I can't seem to get this to work correctly. I seem to be able only to get a Combo Box with ALL Last Names listed (which sort of defeats the purpose of the parameter query, in my humble opinion).
Could anyone point out the error of my ways?
Thanks
S
