on open

[benc]

i have a gv set called vlevel i would like to set an on open code that if vlevel is defaultuser then certain items on the form will not be shown and in instead other details are i have tried the following but cant get it to work.

select case vlevel

case "default user"

credit details.visible = false

case "credit controller"

credit details.visible = true

end select

i also have a cancelled toggle button so if that record has been cancelled i would like

if me.cancelled = true then

me.labelcancelled.visible = true

end if

i cant get either to work can anyone help

thanks

 

[glynch]

I'm assuming that this code is in the OnOpen module of the report. I seem to recall that a report can't "see" all of itself at the OnOpen stage, maybe that is the problem. Look up in Help about the order of events for opening different objects. Maybe your code will work better inside another event module.

HTH