Hello all
I am trying to get records to display on a form in unbound combo boxes when I have previously selected a record.
Data Structure
table - QuoteLog - Primary Key - QuoteID - Subkeys ClientID, ContactCOID and BidPOCID (these last two are records of tbl_ClientContacts)
table - Clients - Primary Key - ClientID
table - ClientContacts - Primary Key - ContactID
Form - QuoteLog - this is based on tbl_QuoteLog
I have 3 unbound combo boxes on this form
The records save correctly in tbl_QuoteLog, however, after I close the form and re-open, the records in Client are typically correct, but the records in Contracting Officer and Bid POC are not showing.
I also have the Select the Client Combo Box again to get the correct list of Contacts to be listed in the 2nd and 3rd Combo Boxes.
My 2 questinos
1. How do I get the previously selected records to appear in those boxes?
2. How do I get the Combo Boxes for Contracting Officer and Bid POC to "see" the record showing in Client without re-selecting the Client?
Thanks,
Mark
Let me know if I am not clear on something.
I am trying to get records to display on a form in unbound combo boxes when I have previously selected a record.
Data Structure
table - QuoteLog - Primary Key - QuoteID - Subkeys ClientID, ContactCOID and BidPOCID (these last two are records of tbl_ClientContacts)
table - Clients - Primary Key - ClientID
table - ClientContacts - Primary Key - ContactID
Form - QuoteLog - this is based on tbl_QuoteLog
I have 3 unbound combo boxes on this form
- 1. Pulls the list of Clients - code saves the ClientID to tbl_QuoteLOg
- 2. Contracting Officer - Selects from tbl_ClientContacts the people who work for the Client and have the position Contacting Officer
- 3. Bid Point of Contact - Selects those who are checked as BidPOC from the company selected in the first combo box
The records save correctly in tbl_QuoteLog, however, after I close the form and re-open, the records in Client are typically correct, but the records in Contracting Officer and Bid POC are not showing.
I also have the Select the Client Combo Box again to get the correct list of Contacts to be listed in the 2nd and 3rd Combo Boxes.
My 2 questinos
1. How do I get the previously selected records to appear in those boxes?
2. How do I get the Combo Boxes for Contracting Officer and Bid POC to "see" the record showing in Client without re-selecting the Client?
Thanks,
Mark
Let me know if I am not clear on something.