Why does Parameter dialog box appear?

[RobertJohn]

I am using Access 2007. I have created a table named Birds with one of the fields called In Captivity. This is a Yes/No field. I have also created a report on which I want to print the words "Yes" or "No" dependiong on the value of the In Captivity field. I tried to do this by adding a text box containing the following expression:

=IIf([Birds]![In Captivity] = XXX, "Yes", "No")

where in place of the XXX I have tried Yes "Yes" 1 and even left it blank. When I try to run the report I get a Dialog Box headed Enter Parameter Value.

Why does this appear? More importantly, how can I stop it appearing?

Thanks in advance

Robert

[Rabbit]

I am using Access 2007. I have created a table named Birds with one of the fields called In Captivity. This is a Yes/No field. I have also created a report on which I want to print the words "Yes" or "No" dependiong on the value of the In Captivity field. I tried to do this by adding a text box containing the following expression:

=IIf([Birds]![In Captivity] = XXX, "Yes", "No")

where in place of the XXX I have tried Yes "Yes" 1 and even left it blank. When I try to run the report I get a Dialog Box headed Enter Parameter Value.

Why does this appear? More importantly, how can I stop it appearing?

Thanks in advance

Robert

Access doesn't know what Birds![In Captivity] refers to so it asks you to provide the value. You can't refer to a field in a table in that manner. Your report should be bound to that table so you only need to use [In Captivity].

The value you're looking for is True/False. No quotes.

[RobertJohn]

Many thanks. That fixed it.

Cheers

Robert

[Rabbit]

Not a problem, good luck.