Quick Button Question (1 Viewer)

[theformula]

I have a particlar form with a ButtonA and FieldA. When ButtonA is clicked, I want it to open up FormA ONLY if FieldA says "Regulatory". If FieldA says "non-Regulatory" I want ButtonA to open FormB.

Any suggestions?

Thanks!

Warren

 

[KeithG]

Let say textboxA contaims fieldA data and textb contains fieldb

if textboxA="Regulatory" then
docmd.openform "FormA"
elseif textboxA="non-Regulatory" then
docmd.openform "formB
End if