help beginner with expression

[wblue]

This used to be simple in Approach, but I do not know how to begin here in Access.
I am entering a new record in a form. One field (A) has three possible values. When closing this form, I want one of three possible forms to open automatically depending on the value entered in A. If A = X, open form 1; if A = Y, open form 2.....and so on.

 

[AnnabelleMarie]

In the form close event, try this:

If A = X then
DoCmd.OpenForm "form1"
elseif A = Y then
DoCmd.OpenForm "form2"
elseif A = Z then
DoCmd.OpenForm "form3"
end if

Hope this helps.