Combo Box Dilemma

[Karyn]

I have a combo box that when you select an item in the drop down box, it brings up related data in the other three fields. My problem is when one of the fields is empty I am getting a zero length string error. What code do I need to write that will accept fields that are blank?

My second problem is when I tried to add a new "Customer Name" to the combo box, it says that the item is not in the list. I tried creating an update query but I am not sure that is right. The data is stored in my table. When you update a field does it store it in the table or query?


Any help is greatly appreciated.

 

[Travis]

Second Problem:
You will need to requery the field after you do the Append Query to see the value. (me.FieldName.Requery)

or you can manually requery with Shift+F5

 

[R. Hicks]

For your first question:
You need to open your table in design view, then select each of the field that you wish to accept a null value and change the Allow Zero Length property to "Yes", the default is "No".

As for the second question:
This is more complicated. Being you are using multiple fields from a table to populate the combo box, you will need to built a form to enter these values with it's control source set to the table in question. What you will need to do then is use the Not In List event of the combo box to open this form where you can enter the values for the multiple fields, then close this form and requery your combo box to update the added info to the combo box.

Good Luck
RDH

[This message has been edited by R. Hicks (edited 05-24-2000).]

[This message has been edited by R. Hicks (edited 05-24-2000).]

 

[Karyn]

Thanks for your help on question #1. Its works great!!!!!!!!