I am trying to make a small help desk db with 'Issues' and 'Resolution' text boxes. The wrinkle (for me anyway) is I also want to have a combo box for 'Common Issues' that will have the top 5-10 calls and resolutions that also auto update the 'Issues' & 'Resolutions' fields.
I have figured out a way for this to work (sort of), but it required 'binding' the text boxes to a Common Issues table and it populates correctly, however then I cannot enter in text if it is not a common issue.
Is there a way (or code) that I can attach to the Common Issues combo box that if selected will copy and paste the Issues and Resolutions, into the main DB/form while also maintaining the ability to enter text in those boxes if it is not a Common Issue?
This is assuming your field names are like what you called them in your post, and that the 'Resolution' is found in the second column (".Column(1)" because column starts it's counting at zero (0)).