>>Hello Cetin,
>>no I don't use Prompt field, I set everything using the property sheet, RowSourceType = Fields, ControlSource = tablename.field1,field2 etc..., as I said it only happens occasionally and if I remove the combo and replace it, the problem goes away
>>Funny old life
>>Regards
>
>Pete,
>
>If this message is accurate then the problem is that you have confused ControlSource with RowSource. ControlSource is the item that will be updated by the combo, RowSouce is the item that will be used to populate the combo's list.
>
>It is
RowSource that needs to be Alias.Field,Field2,Field3.
Jim,
I meant RowSource, if I do as you say (remove Rowsource etc...) it does fix it but what's happening here
Thanks again
Pete
Regards,
Peter J. Kane
Pete