I am new to Access 2007, and I am having dificulty with the combobox properties in my form.
Let me explain: I have created a form with a subform. The main form consists of one field displayed in a combo box, when an item is selected from the pulldown the subform displays it's info.
The problem is when I select an item from the combo box pulldown it is assumed that I want to update the db field. The little pencil comes up, and I get a pop-up with an error because the db field is defined as a unique. Cannot insert duplicate key yada, yada, yada.
How do I disable the edit feature on the combo box?? I have tried setting all of the different properties, but none of them seem to disable the edit function. I really don't want to write any VB code or macros - Is there an easy solution to my problem?