D
Don
I hope I can explain this thoroughly.
I have a main form that shows sale unit data for a particular
SaleUnitID. Within that form, I have a subform that allows the user to
enter bid data into a bid table linked by SaleUnitID.
I would like a combo box in the main form that, when dropped down,
allows the user to pick the winning bidder from the bidders who have
bid on the current SaleUnitID that is being displayed in the subform.
I've tried using this in the row source type:
SELECT [Bid Table].BidName FROM [Bid Table] WHERE ((([Bid
Table].SaleUnitId)=[Bid Subform].SaleUnitID));
However, the combo box always prompts for the parameter of [Bid
Subform].SaleUnitID when clicked rather than recognizing what
SaleUnitID is currently being displayed in the subform.
Any input would be greatly appreciated. Thanks in advance.
I have a main form that shows sale unit data for a particular
SaleUnitID. Within that form, I have a subform that allows the user to
enter bid data into a bid table linked by SaleUnitID.
I would like a combo box in the main form that, when dropped down,
allows the user to pick the winning bidder from the bidders who have
bid on the current SaleUnitID that is being displayed in the subform.
I've tried using this in the row source type:
SELECT [Bid Table].BidName FROM [Bid Table] WHERE ((([Bid
Table].SaleUnitId)=[Bid Subform].SaleUnitID));
However, the combo box always prompts for the parameter of [Bid
Subform].SaleUnitID when clicked rather than recognizing what
SaleUnitID is currently being displayed in the subform.
Any input would be greatly appreciated. Thanks in advance.