Parameter Query - No Null Record Msg

[Dan Kenton]

I've designed a form based on a parameter query that works nicely however I've discovered that if a user enters a response that is not contained in the control source, Access displays a blank datasheet instead of a Null message. How can I get Access to display something telling the user that the data they entered does not exist and returns them back to the parameter box?

Thanks

[ajetrumpet]

I don't think you can. queries can't do it, I don't think. But you can do that alt. action. And that is, giving your own popup box with a small form object, and validating the input in code. If valid, open the form and change the recordsource to the sql of the query you have now. If not valid, close the form and open it again in code:

if notvalid then
    docmd.close acdataform, me.name
    docmd.openform "formname"

[Dan Kenton]

Thanks AJ, that's what I figured. However, I'm not quite understanding your solution. Where is this code supposed to reside? In a macro? I can't see where a macro has an user-input command.

Thanks!

[ajetrumpet]

it's supposed to go behind the form's load event. that's the way I have done it in the past.

[a1061]

I am new to access and I have this exact issue. How did you get it resolved. I see the code that was included but am not sure where this goes and what other code is missing. I did put this in an expression on the on enter form, but it did not work. Any help is greatly appreciated. Thanks!