NearImpossible
Registered User.
- Local time
- Today, 07:33
- Joined
- Jul 12, 2019
- Messages
- 225
I have a ticket form created where the tech enters the callers name and phone number each in their own field. [FacilityPOC] & [POCPhoneNumber]
What I would like to do is change the name field to a combo box so they can select it to see a previous list of names and numbers to select from, or if it doesn't exist, they can just enter it.
I created query to pull the desired information and populate the combo box and have the following code in the Facility POC Combo Box After Update
so when a name is selected from the list, it is populated in the [FacilityPOC] field and their Phone Number is populated into the [POCPhoneNumber] field.
This issue I am running into is that some customers could have multiple phone numbers so the query pulls their name twice, with the associated phone number, but no matter which entry I select from the Combo Box, it always pulls the first record for that person.
Ex.
Comb Box is populated with
Bob Smith - 123-456-7890
Bob Smith - 123-987-3210
John Jones - 145-987-6523
Mary Smith - 123-456-9870
and if I select the entry of Bob Smith - 123-987-3210 from the combo box, it is populating Bob Smith in the [FacilityPOC] & 123-456-7890 in the [POCPhoneNumber] field
What I would like to do is change the name field to a combo box so they can select it to see a previous list of names and numbers to select from, or if it doesn't exist, they can just enter it.
I created query to pull the desired information and populate the combo box and have the following code in the Facility POC Combo Box After Update
Code:
Me.[Facility POC] = [Facility POC Combo].Column(0)
Me.[POC Phone] = [Facility POC Combo].Column(1)
so when a name is selected from the list, it is populated in the [FacilityPOC] field and their Phone Number is populated into the [POCPhoneNumber] field.
This issue I am running into is that some customers could have multiple phone numbers so the query pulls their name twice, with the associated phone number, but no matter which entry I select from the Combo Box, it always pulls the first record for that person.
Ex.
Comb Box is populated with
Bob Smith - 123-456-7890
Bob Smith - 123-987-3210
John Jones - 145-987-6523
Mary Smith - 123-456-9870
and if I select the entry of Bob Smith - 123-987-3210 from the combo box, it is populating Bob Smith in the [FacilityPOC] & 123-456-7890 in the [POCPhoneNumber] field