S
Slez via AccessMonster.com
Will a multi-select list box display records when it is a control on a
subform?
I have a multi-select list box called lstBidSelect, in which the row source
is: SELECT Bid.BidNumber, Bid.BidType, Bid.BidStatus FROM qryBid WHERE (((Bid.
ProjectID)=Forms!frmMainScreen!cboProjectName)) ORDER BY BidNumber;
When I place lstBidSelect on a subform that exists on frmMainScreen or if I
place it on another form called frmEstimateSelector and inserted that as a
subform of frmMainScreen, it doesn't display any records. HOWEVER...If I
open frmEstimateSelector via command button, it displays the proper records
related to "frmMainScreen!cboProjectName".
When I placed frmEstimateSelector as a subform, I linked the proper fields
necessary to relate the records properly. I have other subforms that work
properly, so I am ruling out any "linking" issues.
Is there possibly another setting or event required, or is it a normal
limitation of Access that a multi-select list box will not return the records
in, as, or part of a subform?
Thanks in advance for any suggestions!
Slez
subform?
I have a multi-select list box called lstBidSelect, in which the row source
is: SELECT Bid.BidNumber, Bid.BidType, Bid.BidStatus FROM qryBid WHERE (((Bid.
ProjectID)=Forms!frmMainScreen!cboProjectName)) ORDER BY BidNumber;
When I place lstBidSelect on a subform that exists on frmMainScreen or if I
place it on another form called frmEstimateSelector and inserted that as a
subform of frmMainScreen, it doesn't display any records. HOWEVER...If I
open frmEstimateSelector via command button, it displays the proper records
related to "frmMainScreen!cboProjectName".
When I placed frmEstimateSelector as a subform, I linked the proper fields
necessary to relate the records properly. I have other subforms that work
properly, so I am ruling out any "linking" issues.
Is there possibly another setting or event required, or is it a normal
limitation of Access that a multi-select list box will not return the records
in, as, or part of a subform?
Thanks in advance for any suggestions!
Slez