Hello Everyone

I'm Trying to use NotInthelist Fuction in one of the combo boxs in my form, as i downloaded the not in the list from this website
Visit this Website

but when i compile access give me a compile error

ambiguous name detected: GProductName

GProductName is defined as Global GProductName As String in a model

any ideas

Thank you in advance

You must have defined it in a different place in your code already. Globals are, well, global in scope. No need to define them over and over. And, as you can see, it doesn't work anyway.

Find the other instance(s) and decide which one you want to keep.

Thank you that was the case