Allowing blank entry in combo box (1 Viewer)

[tsteinh]

I have a combo box that is populated from an Access table. This is working fine, except that I want the user to be able to use a barcode reader to wand in a selection. In order to do this, I'd like to be able to clear the combo box entry on an Add so that they can either wand the value or select a value from the list. Unfortunately, a blank value is not valid, since the underlying table does not have a blank entry. I get an error saying that the entry is not one in the list. I have also set LimitToList to 'No' but still get the message. Is there a way to add " " as another valid selection to this list? I do not want to add a blank entry to the underlying table since it would complicate other processes.

Thanks for the help!

 

[Abby N]

Hello. Here are a couple of short articles that may help you out. You can use the method from the first article to add a blank line to your combo box. The second article will explain how to use the NotOnList event to automatically add a new entry into your combo. I hope they help.

• Adding "All" to a listbox or combobox
• Add item to combo box using OnNotinList event

~Abby


[This message has been edited by Abby N (edited 03-26-2001).]