report coding

[skate]

I am having some problems regarding using code in a report (as I've never done this before). I have a function that makes a textbox visible/or not depending on the value of another field MOrder, which is somewhat like an index field but can only be a number from 1 to 12. Normally the report is opened from the form which will only view the report for eg. MOrder=3. When i call the function on Report_Open it says "the expression entered has no value" and refers to my statement If MOrder=3 then....

Any help would be appreciated.

Thanks.

 

[Junior1544]

try looking at the
Detail_Format
event handler... I think that'll work better for you...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[skate]

sorry, I don't know what that means...

 

[Junior1544]

ok, What version of access are you using? junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[skate]

access 2000
sorry, but I relatively new with using access and don't know my way around things very well...