Greetings to the well of knowledge...
I have an unusual issue that I can't seem to resolve.
I have a table with a field named "Payee". I want the user to have a choice of free-form typing a name or selecting a name from a drop down. I initially tried to create a combo box control with LimitToList set to false, but this did not do what I thought I could do by setting this property...I was still limited to selecting from the drop down list only.
So I came up with an alternative, if unwieldy approach:
1. Create a hidden text box control on the form named "Payee", the control source for which is the table field "Payee".
2. I created an unbound text box named "PayeeText".
3. I created an unbound combo box named "PayeeCombo". The list is created via a query of a separate table of specific names.
4. I created a command button that allows the user to toggle between either PayeeText or PayeeCombo. I do this by making PayeeCombo visible and PayeeText not visible, or vice versa.
5. Within the VBA code for the control, I accept whatever input I get (either free text or drop down item) and then assign the value of the field back to the hidden control "Payee", which then updates the table.
Seems like a good approach in theory, however, the text box, "PayeeText", will not accept any input at all. I checked the obvious: it is enabled and it is unlocked. The only thing it responds to is when I click at the end of the text box and then type Backspace...in this instance the text in the control is highlighted.
I'm baffled. Any ideas?
Thanks,
Ken