Enter Parameter Value when combo box selected

[hgoslin]

Hi
I have very little Access programming background and I am trying to
get the following to work:
I have a form: frmTenderDetails which has a bound control
ProposalRefNo to a table which displays the tender number for a
procurement database.

It has a subform that lists all the companies that have been invited
to tender for this job. I have a command button on the subform that
opens a form: frmTenderDocsReceived to display which documentation has
been received for each company in the subform.

frmTenderDocsReceived is based on a filter of the current
ProposalRefNo and shows this value in a text box: txtTenderNo.

I have a query: qryTenderInvCbo which is a parameter query that
displays the Company Names that have been invited to tender based on
tender number. The parameter: [forms]![frmTenderDocsReceived]!
[txtTenderNo] works well when the frmTenderDocs is open - I get the
correct information in the query, but when I set this query as my data
source for the conrol: cboCompanyName, I get "Enter Parameter Value"
Forms!frmTenderDetails!ProposalRefNo when I click on the combo box.
If I type in the Tender Number in the parameter value, the combo box
is populated correctly, but I want the combo box to pick up the value
from the query using - either the current form containing the control
- txtTenderNo or the ProposalRefNo on the original form.

I would appreciate any suggestions.
Thanks
HG

 

[hgoslin]

Hi
I have very little Access programming background and I am trying to
get the following to work:
I have a form: frmTenderDetails which has a bound control
ProposalRefNo to a table which displays the tender number for a
procurement database.

It has a subform that lists all the companies that have been invited
to tender for this job. I have a command button on the subform that
opens a form: frmTenderDocsReceived to display which documentation has
been received for each company in the subform.

frmTenderDocsReceived is based on a filter of the current
ProposalRefNo and shows this value in a text box: txtTenderNo.

I have a query: qryTenderInvCbo which is a parameter query that
displays the Company Names that have been invited to tender based on
tender number. The parameter: [forms]![frmTenderDocsReceived]!
[txtTenderNo] works well when the frmTenderDocs is open - I get the
correct information in the query, but when I set this query as my data
source for the conrol: cboCompanyName, I get "Enter Parameter Value"
Forms!frmTenderDetails!ProposalRefNo when I click on the combo box.
If I type in the Tender Number in the parameter value, the combo box
is populated correctly, but I want the combo box to pick up the value
from the query using - either the current form containing the control
- txtTenderNo or the ProposalRefNo on the original form.

I would appreciate any suggestions.
Thanks
HG

Got it working - Apologies to all for adding clutter to the board