cmbo box on subform fills fields on form when chkbx is yes

[kathrynwoning via AccessMonster.com]

I have a multi-tabbed form that details bid data ranging from pricing to
contact info to departmental notes. Page two has a subform listing general
contractors to whom we bid. One bid may have 10-15 contractors listed. When a
purchase order is issued from one of these contractors I select a checkbox
indicating that GC. I would like the opening page on this tabbed form to show
the address and contact info for that GC when the checkbox is yes. Is this
possible?

 

[Maury Markowitz]

indicating that GC. I would like the opening page on this tabbed form to show
the address and contact info for that GC when the checkbox is yes. Is this
possible?

Is the checkbox a field in the underlying database? If so I'd do an
OUTER JOIN between that field and the addresses, and join that
recordset to the form fields on the first tab. For instance, if the
addresses are in tblGC and the contracts with the checkbox in
tblBids...

SELECT c.[address fields] FROM tblGC c JOIN tblBids b ON b.gcId=g.gcId
WHERE b.DidContract=1

Then make a subform displaying the address fields, bind this query to
it, and then wire up the subform to join on the bid Id.

Maury

 

[kathrynwoning via AccessMonster.com]

???

SELECT qryGenContractors.gcID, qryGenContractors.gcName, qryGenContractors.
gcBusCity, qryGenContractors.linkContractorID, qryGenContractors.linkBidId,
qryGenContractors.linkBidAccepted, qryGenContractors.linkPOreceived,
qryGenContractors.linkAuthorizedBy, qryGenContractors.linkLowBid,
qryGenContractors.linkLBreceived, qryGenContractors.linkLBAuthorizedBy
FROM qryGenContractors; JOIN tblGC ON gcID=linkBidID WHERE qryGenContractors.
linkPOreceived=1

indicating that GC. I would like the opening page on this tabbed form to show
the address and contact info for that GC when the checkbox is yes. Is this
possible?

Is the checkbox a field in the underlying database? If so I'd do an
OUTER JOIN between that field and the addresses, and join that
recordset to the form fields on the first tab. For instance, if the
addresses are in tblGC and the contracts with the checkbox in
tblBids...

SELECT c.[address fields] FROM tblGC c JOIN tblBids b ON b.gcId=g.gcId
WHERE b.DidContract=1

Then make a subform displaying the address fields, bind this query to
it, and then wire up the subform to join on the bid Id.

Maury