I have a combobox with the following characteristics:
Data
Control Source: ContractingOfficerName
Row Source: qryContacts_KOs
Row Source Type: Table/Query
Bound Column: 1 (ContactID, autonumber)
Limit to List: Yes
Allow Value List Edits: Yes
List Items Edit Form:
Inherit Value List: Yes
Show Only Row Source Values: No
Input Mask:
Default Value:
Validation Rule:
Validation Text:
Enabled: Yes
Locked: No
Auto Expand: Yes
Format
Column Count: 2 (ContactID, ContactName)
Column Widths: 0",1.5"
Control Source: ContractingOfficerName
Record Source: tblCases
RescordSet Type: DynaSet
Row Source: qryContacts_KOs
Fields:
ContactID
Table: quniContactsTags, Sort: , Show: yes, Criteria:
ContactName
Table: quniContactsTags, Sort: ascending, Show: yes, Criteria:
ContactTag
Table: quniContactsTags, Sort: , Show: yes, Criteria: "Contracting Officer"
ContactStatus
Table: quniContactsTags, Sort: , Show: yes, Criteria: "Active"
Problem:
Field stores the ContactID, Dropdown List for ComboBox shows contacts from the qryContacts_KOs query which only shows active Contracting Officers. When a contracting officer becomes inactive, they no longer show up in the query or the dropdown list and the combobox displays nothing. The ContactID is still stored in the field but the name is no longer displayed.
Desired outcome:
Continue to display the contracting officer name in the field even if they are not in the query result or the dropdown. The purpose of having the contracting officer not show in the query results is to have a shorter dropdown list by only showing active contracting officers in the dropdown.
Data
Control Source: ContractingOfficerName
Row Source: qryContacts_KOs
Row Source Type: Table/Query
Bound Column: 1 (ContactID, autonumber)
Limit to List: Yes
Allow Value List Edits: Yes
List Items Edit Form:
Inherit Value List: Yes
Show Only Row Source Values: No
Input Mask:
Default Value:
Validation Rule:
Validation Text:
Enabled: Yes
Locked: No
Auto Expand: Yes
Format
Column Count: 2 (ContactID, ContactName)
Column Widths: 0",1.5"
Control Source: ContractingOfficerName
Record Source: tblCases
RescordSet Type: DynaSet
Row Source: qryContacts_KOs
Fields:
ContactID
Table: quniContactsTags, Sort: , Show: yes, Criteria:
ContactName
Table: quniContactsTags, Sort: ascending, Show: yes, Criteria:
ContactTag
Table: quniContactsTags, Sort: , Show: yes, Criteria: "Contracting Officer"
ContactStatus
Table: quniContactsTags, Sort: , Show: yes, Criteria: "Active"
Problem:
Field stores the ContactID, Dropdown List for ComboBox shows contacts from the qryContacts_KOs query which only shows active Contracting Officers. When a contracting officer becomes inactive, they no longer show up in the query or the dropdown list and the combobox displays nothing. The ContactID is still stored in the field but the name is no longer displayed.
Desired outcome:
Continue to display the contracting officer name in the field even if they are not in the query result or the dropdown. The purpose of having the contracting officer not show in the query results is to have a shorter dropdown list by only showing active contracting officers in the dropdown.
Last edited: