The combobox consists description of all the items in the table. Users are able to add new records to the table through input into the combobox as well. That is why I have to let users fill up comboboxes by typing in. I think the maximum size is 50 chars and that's not a lot.
The real limit is 255, but I still don't understand. You can use a TextBox and
then do a DLookUp, but you can't really expect someone to type in something
that long without a mistake.
The real limit is 255, but I still don't understand. You can use a TextBox and
then do a DLookUp, but you can't really expect someone to type in something
that long without a mistake.
I did not think about the DLookUp method before you mentioned it. Maybe you can take a look at my form and give me your 2 cents worth. If the user types in something that can't be found in the database, there will be a form prompted for them to add the item to the database first.
The form im talking about is SubFrmOrderInfo. Thanks!