COMBO BOX shows no records

[rproactive]

Hello all- would sure appreciate help with a combo box that has he going in circles.

When I use the drop down arrow to enter data in this control initially it appears as all blank. Or if I try to enter any data I get ERROR: “The text you entered isn’t an item in the list.”

If I change Column width property to: 1;1;0 (was 0;1;0) the drop down arrow now shows correct values and works but unfortunately stores the primary key value (a number) rather than the text I need.

DETAILS:
I have a form F_DepositSlip
Bound to table M_DepositSlip. There is a simple cboDepositSlipNumber control on the form with:
Control Source: DepositSlipRRSub_IDs
Row Source: SELECT L_RRSub.RRSub_ID, L_RRSub.RRSubName, L_RR.RR_ID FROM L_RR INNER JOIN L_RRSub ON L_RR.RR_ID=L_RRSub.RRSubRRs_IDs WHERE (((L_RR.RR_ID)=Forms!F_DepositSlip!cboRentRollMonth));
Bound Col: 1
Col Count: 3
Col Width: 0;1;0
[This query looks up text (L_RRSubName) based on primary key RRSub_ID in table L_RRSub
WHERE a 2nd control on form (cboRentRollMonth) equals primary key RR_ID on table L_RR]- I think this is a correct description.

Note the Control Source DepositSlipRRSub_IDs in table M_DepositSlip has a Combo Box Lookup with:
Row Source: SELECT L_RRSub.RRSub_ID, L_RRSub.RRSubName FROM L_RRSub WITH OWNERACCESS OPTION;
Bound Column: 1
Column Count: 2
Column Widths: 0;1


I hope I am missing some simple little thing (over and over again Unfortunetly). Help greatly needed- thanks

 

[rproactive]

2 of the combo boxes are cascaded and linked. You must refresh or requery the first so that 2nd displays correct values.

Problem was solved by REFRESH adding after update event