S
Stevebarre
I have a database listing Hymn names. I have a lookup table indexed with
numbers 1-3 and names Processional, Communion, Recessional. The database
field [UseFor]is a lookup field and automatically stores the number 1-3 for
the selection.
When I try to write a report using this database, I want the field [UseFor]
to display the name Processional, Communion, Recessional.
Under the Control Source I have entered: Choose([UseFor], "Processional",
"Communion", "Recessional"). When I entered this, I show a little box next
to the field on the report in design form which says when I click on the
arrow: " Invalid Control Source and Expression must begin with "=" sign. I
have tried that, but I can't get rid of that little error box and I can't
preview the report. Any Idea what I am doing wrong? Is it because of the
Look UP Field in the database that this won't work or what?
Thanks Steve
numbers 1-3 and names Processional, Communion, Recessional. The database
field [UseFor]is a lookup field and automatically stores the number 1-3 for
the selection.
When I try to write a report using this database, I want the field [UseFor]
to display the name Processional, Communion, Recessional.
Under the Control Source I have entered: Choose([UseFor], "Processional",
"Communion", "Recessional"). When I entered this, I show a little box next
to the field on the report in design form which says when I click on the
arrow: " Invalid Control Source and Expression must begin with "=" sign. I
have tried that, but I can't get rid of that little error box and I can't
preview the report. Any Idea what I am doing wrong? Is it because of the
Look UP Field in the database that this won't work or what?
Thanks Steve