3 separate Forms, How do I move each form record forward wih one b

[Guest]

I want to be able to move the record forward in 3 separate subforms on a (tab
page) within my main form, but when I set a macro with the ‘GoToRecord’
command, I get the following error:

The table ‘Final Top 10 A’ is already opened exclusivley by another user, or
it is already open through the user interface and cannot be manipulated
programmatically.

So, I tried putting in an ‘OpenForm’ Command within the macro; but then I
get this error Message:

The Object ‘Final Top 10 Form A’ isn’t open

The macro you are running (directly or indirectly) contains a GoToRecord
action, but the Object Name arguments names an object that is closed.

Use one of the Open Actions or methods to open the object so that you can
carry out the desired action

Does anyone know how I can simply get 3 separate forms to advance 1 record
forward, siumultanously?. This is to save the user pressing 3 separate
buttons (1 for each form)

The Names of the 3 forms are:

Final Top 10 Form A
Final Top 10 Form B
Final Top 10 Form C

 

[Guest]

the way to handle this by code is:
first, are the 3 forms sub-forms of 1 main form? if so, on which of the
forms the user initiates the record-progression? or is it a "next" button of
some sort? if it is then on this button's Click event write:
frm1.form.recordset.movenext
frm2.form.recordset.movenext
frm3.form.recordset.movenext

where frm1 is the name you gave to the sub-form control which is made of
Form A,
frm2 is the name you gave to the sub-form control which is made of Form B,
and frm3 is the name you gave to the sub-form control which is made of Form C

to get real results, start learning vb code, it's so much more pwerful than
macros.