Stopping for User Input with conditions

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
 
F

fredg

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?])
 
D

Duane Hookom

I heard fredg chirping :) Did you not hear his reply? Or, did you not
understand his dialect of cricket-speak?
 
Top