Originally Posted by
KACJR
...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...
Then your Combobox Control must have been corrupted! A Combobox that is Bound to the Payee Field, with Limit to List set to No (which is the Default setting, at least in v2007) should work exactly as you require! You can make a selection from it or enter data into the Combobox's blank box from the keyboard.
I would
- Delete the original Combobox (if it is still on the Form)
- Create a new Combobox
- Set its Control Source to Payee
- Set LimitToList to No
Linq ;0)>
A late thought about why you couldn't enter Data into the Textbox: Are you absolutely sure that, while trying to come up with an approach, you didn't enter an expression/calculation in the Control Source for the PayeeText Control? That would account for it being uneditable.
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007