Reffering to the "Active" form in a calculation.

[Computer202]

Hey Guys...



I have already spoken to someone of the forums regarding this. What I wanted was to take a value off a field in a macro.

Assuming in this I have 4 forms, Frm1, Frm2, Frm3 and Frm4. Each of these have the same button which works on the same code to do a process which isn't relevant. Before it carries out the process I want it to take 1 of the field (QTY). This field is present in all the forms. At the moment I have:

Form!Frm1.QTY = Form!Frm1.QTY - 1

The problem with this being if I am on frm2 to frm4 this wont work... How can I set it to the active form instead of specifying?

Cheers

(Thanks pbaldy for help so far )

[pbaldy]

Check out ActiveForm in VBA help. It will refer to the form that currently has focus.