Below is the Data form the SQL view which is in the Row Source for a Combo Box (Name of Combo [ClassandCage]
SELECT Entries.ClassID, Entries.CageNo
FROM Entries
ORDER BY Entries.ClassID, Entries.CageNo;
This provides the data I want to select.
Below is the Control Source for two Text Boxes
=[ClassandCage].Control(0)
=[ClassandCage].Control(1)
The data in the Entries table is listed (ClassID column then CageNo)
eg 1 1
1 2
1 3
21 1
21 2
When I select a combination from the Combo Box it always shows the correct ClassID in its Text Box but the CageNo always display 1. I have added another field from the Table to the Combo Box and another Text Box (ExhibitorID) with the Control(2) and it displays the correct Info. I cannot understand why I cannot get the CageNo to display the correct number(Column(1). Any suggestions would be appreciated.
SELECT Entries.ClassID, Entries.CageNo
FROM Entries
ORDER BY Entries.ClassID, Entries.CageNo;
This provides the data I want to select.
Below is the Control Source for two Text Boxes
=[ClassandCage].Control(0)
=[ClassandCage].Control(1)
The data in the Entries table is listed (ClassID column then CageNo)
eg 1 1
1 2
1 3
21 1
21 2
When I select a combination from the Combo Box it always shows the correct ClassID in its Text Box but the CageNo always display 1. I have added another field from the Table to the Combo Box and another Text Box (ExhibitorID) with the Control(2) and it displays the correct Info. I cannot understand why I cannot get the CageNo to display the correct number(Column(1). Any suggestions would be appreciated.
