Stopping for User Input with conditions

  • Thread starter Thread starter Kathy Webster
  • Start date Start date
K

Kathy Webster

If the numeric field in a report's underlying query = 47, I want the report
to print "Los Angeles." If the field says something other than 47, I want
the report to stop and prompt the user to enter the city before the report
prints. How can I do this?

TIA,
Kathy
 
If the numeric field in a report's underlying query = 47, I want the report
to print "Los Angeles." If the field says something other than 47, I want
the report to stop and prompt the user to enter the city before the report
prints. How can I do this?

TIA,
Kathy
Click to expand...

As control source of an unbound control in the report:
=IIf([SomeField] = 47,"Los Angeles",[What?])
 
I heard fredg chirping :-) Did you not hear his reply? Or, did you not
understand his dialect of cricket-speak?
 
Back
Top