Form Field Issue (1 Viewer)

Hi again
I'm using Access 2007.

I've created a table with two fields. "Novice and Recertification" as in combo box.
I put it on the form. Now the idea is when a user clicks Recertification, it shows up on the report. When the user clicks on Novice, it should be empty on report (Reason why I want to keep novice is so that we have a record of it.)
Now the challenge is I added another column, empty field for Novice and Recertification for Recertification. Thing is if I set the bound column, I select on an empty field on form and it will be empty on report. But I want the user to see Novice on the form and it must not show on the report.

I hope I described the hassle I'm having.

Thanks alot again guys!

You only need 1 field...

Then base your report on a query. In the query, create a calculated field, something like

DisplayThis: iif(somefield="Novice","",somefield)

and use the calculated field on the report

CazB said:

You only need 1 field...
Then base your report on a query. In the query, create a calculated field, something like
DisplayThis: iif(somefield="Novice","",somefield)
and use the calculated field on the report

Click to expand...

Hi CazB!
I get the idea of what you're saying. It didn't work though?
On the form, the novice is blank, but the user needs to see it and click on it.
It's only when the user previews the report that the novice mustn't be seen on the report. So if the user selects recert, then it must show on the report.

Does anyone know what I can do??