Where Condition

[Frank]

I have a Command Button (Edit_Report) on my home page that I would like to
trigger a user to enter a report number and then go to Edit that report. If
the number that the user entered does not exist I would like to tell the user
to re-enter a number or cancel.

How do I start this and is it possible?

I have tried this through an OpenForm macro (Enter_Report_Number) and could
only get the first step to work. If the user put the wrong number in it
would open a new form instead of canceling or prompting the user to re-enter
the number.

Thank you
Frank

 

[Allen Browne]

To see if the number is in the table, use DLookup().
If it returns Null, the number was not found.

For detailed help, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

Once you know that the number is valid, you can open the report filtered to
that record.

Detailed help on that:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html