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

  • Thread starter Thread starter kathrynwoning via AccessMonster.com
  • Start date Start date
K

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?
 
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?
Click to expand...

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
 
Back
Top