I have a Report that I want to display certain fields depending on data in a field. ( Visible - true/false )
I have created an if statement
If Me!SizeScaleGrade = 1 Then SizeScaleGrade_A
If Me!SizeScaleGrade = 2 Then SizeScaleGrade_B
If Me!SizeScaleGrade = 3 Then SizeScaleGrade_C
If Me!SizeScaleGrade = 4 Then SizeScaleGrade_D
If Me!SizeScaleGrade = 5 Then SizeScaleGrade_E
If Me!SizeScaleGrade = 6 Then SizeScaleGrade_F
If Me!SizeScaleGrade = 7 Then SizeScaleGrade_G
If Me!SizeScaleGrade = 8 Then SizeScaleGrade_H
I set it to fire on the On Page event but the first record displays all the records then the records after that work fine?
On the On Open event it doesnt even open the report.
Any idea's out there?
H
I have created an if statement
If Me!SizeScaleGrade = 1 Then SizeScaleGrade_A
If Me!SizeScaleGrade = 2 Then SizeScaleGrade_B
If Me!SizeScaleGrade = 3 Then SizeScaleGrade_C
If Me!SizeScaleGrade = 4 Then SizeScaleGrade_D
If Me!SizeScaleGrade = 5 Then SizeScaleGrade_E
If Me!SizeScaleGrade = 6 Then SizeScaleGrade_F
If Me!SizeScaleGrade = 7 Then SizeScaleGrade_G
If Me!SizeScaleGrade = 8 Then SizeScaleGrade_H
I set it to fire on the On Page event but the first record displays all the records then the records after that work fine?
On the On Open event it doesnt even open the report.
Any idea's out there?
H