Wrong input = error msg

[kabir_hussein]

Hi


does anyone know if there is a way of doing a query where if a user does not type in something or they type something in that is not correct into a msg box, an error message will appear on screen

many thanks

 

[Mile-O]

You know, for all the questions you have on parametersm, queries, etc. I'm surprised you aren't using a form.

With a form you can test the selection, inform the user to put sense into the criteria, and only then open the report.

 

[kabir_hussein]

hi

thank you for your reply i do understand what you mean, what i am trying to do is do a query where the user is asked to type in a purchase number to open up another form, from that page the user can edit data.

however to edit data the user will need the correct purchase number, however if a user types in an incorect number one that does not exist. i am trying to make an error msg pop up on screen and also if the user does not type anything into the msg box the same error msg appears

if you know what i mean, if not pls reply back to me

many thanks once again