Parameter Dialog Box

[Valerie]

I have never worked with Access before, and am trying to create my first
database in Access 2000. I have a Query with an Expression that asks for a
value. This works fine, the problem is the popup dialog box gives the full
name [Forms]![PrintSubForm]![ClientNumber], which is not very descriptive to
the end user. Is there an easy way to give this a more descriptive name?
Thanks
Valerie

 

[Howard Brody]

it looks like you used the ClientNumber control on the
PrintSubForm as the criteria for your client number but
you're runnig the query without the form being open.

If it's in brackets, Access will view it as a field and
look for it when the query runs. If it's not found, it
displays a dialog box with the 'field name' for the user
to enter.

I've used this to make Access ask for date ranges (with
criteria: Between [Enter First Date] And [Enter Last
Date]) and similar things.

You can change the criteria from [Forms]![PrintSubForm]!
[ClientNumber] to: [Please Enter Client Number]. The only
problem with that is then, even if the form is open and
the field is populated, it will ask for the client number.

I'd run the query from the form using a command button and
code it to make sure a client number was entered ... or
selected in a combo box (less chance for error).

Hope this helps!

Howard Brody