Problem creating a TempVars

[Welshgasman]

So you set the tempvar to a null value,as Me.txtpermission had no value?


Walk through the code LINE BY LINE with F8 and hover over the variables to see what they contain.

[Ant_Snell]

@Welshgasman Thanks I'll give that a go this evening but got to go out now. Thanks for all the help

[Welshgasman]

Ignore this post

[moke123]

I may be missing it but where are you setting the value of Me.txtPermission?

I would expect to see

me.txtPermission = ab.Permission

[orange]

integers and strings can't contain Null.You can also use the Nz function to replace Null with an empty string if referred to as a string, or 0 if referred to as an integer.

You could try

1: If Me.txtPermission.Value is a string

if nz(Me.txtPermission.Value,"") ="" then
 msgbox "txtPermission has no value"
else
   TempVars.Add "UserPermission", Me.txtPermission.Value
MsgBox TempVars![UserPermission]     
end if

2: If Me.txtPermission.Value is a number

if nz(Me.txtPermission.Value,0) =0 then
 msgbox "txtPermission has no value"
else
   TempVars.Add "UserPermission", Me.txtPermission.Value
MsgBox TempVars![UserPermission]     
end if

[Ant_Snell]

Using combinations of all help/suggestions, I have now got this sorted. Thanks

[orange]

Good stuff. Members are here to help.