Adding to a combo box

[indesisiv]

Help -

I have a combo box that runs a simple search and also has an add facility on the not in list event.

The problem is that it seems to be adding 2 rows into the combo box instead of just once but i can't figure out why it adds the second row.



It is very hard to explain what is happening so i have attached the database (or most of it) so that you access gurus can have a look.

 

[Mile-O]

I can't see anything wrong with your combobox. Your error handler may be interfering but I tried a few times and nothing unsightly happened.

 

[indesisiv]

Thaks for the uick response Mile but

Sorry my mistake,
I have two variations on the error.
I either have the double in the combo box or i get :

On that version the error
If you type data into the subform after you have added to the combo box it does not assign it a value so that when you try and view it .. it is not there because it have no ID number associated with it.

If you look at the autonumber bit then after the update it doesn't set.

An ideas??

Steve