Form Filter Combo - msgbox when user tries to enter data here

[Richie27]

Hi all,



I use filter Combo boxes in a lot of places so that users can filter records easily. (Not combo boxes for input)

I have them labeled as filters but nonetheless users keep trying to input into them for some reason.

How would I add a message box to it so that it states that 'this box is not for data entry etc'

Is it the on dirty event or something like that?

Thank ya kindly,
Rich.

[John_G]

Hi -

Set the LimitToList property to True, and use the Not in List event to display your custom error message. You can suppress the MS Access error message by setting response (it's one of the event parameters) to acDataErrContinue (that is for A2003)

HTH

John

[Richie27]

Hi -

Set the LimitToList property to True, and use the Not in List event to display your custom error message. You can suppress the MS Access error message by setting response (it's one of the event parameters) to acDataErrContinue (that is for A2003)

HTH

John

Thanks, worked nicely!