You've already chosen that

[tacieslik]

Hello,

Does anyone know a macro that would let me choose a supplier from a combobox 'once', and then if I tried to choose the same supplier on a different record, put a message box up saying that I've already chosen that supplier??

 

[Chris RR]

I think that you would have to do a dlookup in VBA to see if the field was already used.

 

[tacieslik]

Thanks Chris RR,

I'll try and find out how to use the dlookup.

Regards,
Tim Cieslik