If value isn't in combobox list Then.. (1 Viewer)

[maw230]

Is there a built-in property to check if the value in a combobox is in the RowSource or not?

I want to show a label on my form if the value entered in the combobox isn't in the "list".

 

[CJ_London]

depends on your access version but look at the 'not in list' event. If you don't want users to add something that is not in the list set 'limit to list' to yes

 

[maw230]

I don't think this will work as I don't want to limit to list I just want a warning to display if something isn't in the list.

 

[CJ_London]

in which case as I suggested

depends on your access version but look at the 'not in list' event.

 

[maw230]

in which case as I suggested

I must not have it configured right then. I will take another look.

 

[maw230]

depends on your access version but look at the 'not in list' event. If you don't want users to add something that is not in the list set 'limit to list' to yes

Hi CJ. The Not in List event only works when Limit to List is set to Yes. I think I will need to go about this a different way.