iif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to put a if statment in a "On Timer" Event a form. I want the iif
statment to look at object "GetOut", and if it is equal to 1 then run
"fGetOut" if not run "Refresh_Data"

fGetOut is afunction that kicks the user out of the entire database.

By doing this I will be able to go into back_end and check a box that will
then update to every user version every thirty seconds. Once the user box
gets checked through the "Refresh_Data", after the next thirty seconds it
will Kick them out.

Please help me form this if statement. I already have the code written for
the "fGetOut" and the " Refresh_Data".
 
Professional_in_need_of help said:
I want to put a if statment in a "On Timer" Event a form. I want the
iif statment to look at object "GetOut", and if it is equal to 1 then
run "fGetOut" if not run "Refresh_Data"

fGetOut is afunction that kicks the user out of the entire database.

By doing this I will be able to go into back_end and check a box that
will then update to every user version every thirty seconds. Once
the user box gets checked through the "Refresh_Data", after the next
thirty seconds it will Kick them out.

Please help me form this if statement. I already have the code
written for the "fGetOut" and the " Refresh_Data".
Click to expand...

In code you seldom use the IIf() function, but instead use an If-Then block.

If GetOut = 1 Then
fGetOut
Else
Refresh_Data
End If
 
Back
Top