Combo box problem

S

SHIPP

I have the following SQL for a combo box on a subform.

SELECT DISTINCTROW tblDivision.DivisionID, tblDivision.DivisionNo,
tblDivision.DivisionName FROM tblDivision ORDER BY tblDivision.DivisionName;

The subforms record source is.

SELECT tblConDiv.ContractID, tblConDiv.DivisionID, tblDivision.DivisionNo,
tblDivision.DivisionName, tblConDiv.PercentContract FROM tblDivision INNER
JOIN tblConDiv ON tblDivision.DivisionID = tblConDiv.DivisionID ORDER BY
tblDivision.DivisionName;

This is strange. The underlying tblDivision has 14 records. If I am on a
record on the subform which doesn't include the last 6 records then they do
not show in the drop down(no slide either on the right side). If I am on a
record that contains one of the last 6 records then all 14 records in the
combo box show in the drop down (the slide bar appears). By the same token if
I am on a new record on the sub-form all 14 records show in the drop down.
Any ideas would be greatly appreciated. This is driving me crazy.
 
Top