I'm creating form with combo box wh

[talsh]

I'm creating form with combo box which is lookup to data list in table (this table need to stay as is without changes, the data is corresponding to other table by ID field) when I'm choosing one value in this combo box this value is duplicat it salf in this table.

How can I prevent this problem?


Thanks in advanced

 

[Darrylles]

Hiya,

Delete whatever you have in the <Control Source> property of the combo, leave whatever you have in the <Rowsource> property.

Regards

Darrylle

&quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot; darrylles@totalise.co.uk

 

[talsh]

This solve half of the problem the master table with the lookup to the ID in the data is also not update and this table I want to update.