Reports

GSchafer1

Registered User.
Local time
Today, 15:41
Joined
Mar 13, 2000
Messages
22
I'm extremely stupid today, so I need help. I have a textbox(Cool)on a form named(Contacts). This textbox has a number from 1 to 10 entered in it by an operator. I've got a report generated from a quary from that form named(Contact Quary). That brings up a single file report based on a Contact name and some other Label's. Based on the number entered in[Contacts.Cool] I would like to have an "X" put into another label with a Name Label1, Label2, Label3, etc. So if Cool(number) is 1 then put an "X" in Label1.Caption, If Cool(number) is 2 then put an "X" in Label2.Caption. Help please!
 
On your report " On Open" event try this code:
select case [cool]
case 1
label1.caption = "X"
case 2
label2.caption = "X"
case n
labeln.caption = "X"
end select
 

Users who are viewing this thread

Back
Top Bottom