Alias

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I have a query with a check box. From a previous posting I can use this
code: (from fredg)

Like IIf(IsNull([Which ones?]),"*",[Which ones?])

for a parameter that determines what will show up in my corresponding
report. -1, 0 and space, display checked, not checked and all records. Works
great. For users, is there a way to tag the parameter message box (right now
it says "Enter parameter value") with something explaining what is needed?

Or is there a way I can take input (example - Yes, No, All - or something
similiar) and convert into the -1, 0, space I need in the parameter.
Otherwise, how is the user going to know what to input?

thanks.
rob
 
You should lift your application development up a notch and use controls on
forms. This allows you to provide tons of information to your users, set
defaults, test integrity, use list/combo boxes & option groups, view more
than one parameter at a time, save parameters,...
 
Back
Top