Insert is making data selection impossible

del_toro02

I am trying to select a customerID from a list but when I click on the arrow to open the customers list, I get an error message because the key field for the list below is blank.
I can get rid of this error message if I set the "enable" property for the list to "no" but I am then not able to modify any data in this list.
Can anyone help ?
Check image for more information as it won't be clear for any of you without it.
if you need more info, let me know.

DaveT

Hi,

It look to me as you are opening the form filtered so no customer are listed. The error comes from the tablebox tring to insert a record into the customer table with a blank code. Where/how are you calling this form?

del_toro02

in the case I mentionned, not customers are in the list. in the case where customers are in the list, it works just fine.
i am calling a table "customer" from the dropdown box and this is when I get this error message because the table "customer" has a property that doesn't allow blank fields for the key.

DaveT

Hi,

Try using the DelayInsert property to solve this for you.

del_toro02

it works perfectly after changing the delayinsert value of of form properties.

thanks !

DaveT

I'm still confused what you are trying to acheive - should the user be allowed to create customers from this list? Seems a bit dangerous to me.
Anyway Gald to Help

del_toro02

no, the window you see in the image is actually a "popup window" that enables the user to add customers into a list. this list will be used in a report in order to print labels.
for example each Christmas we need to send letters to a certain list of people, so we will create a Christmas list and populate it with the required customers. Same thing for other occasions.
thanks again for the help.