Table Value

P

PCC

I am trying to write an if statement to open a form based
on a value in a table. In other words if rates = 0 then
open form1 else open form2. Is there a way to write that
in access.

Thanks
 
M

Mike Painter

PCC said:
I am trying to write an if statement to open a form based
on a value in a table. In other words if rates = 0 then
open form1 else open form2. Is there a way to write that
in access.

Thanks
Click to expand...

If rates = 0 then
DoCmd.openform Form1 ' see help for arguments.
else
DoCmd.openForm Form2
end if

It's a good idea to read through everything that DoCmd can do.
 
Top