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 is 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)

 

[tina]

please don't multipost. for more information, see
http://home.att.net/~california.db/tips.html#aTip10

hth

 

[Maxi]

I want to be able to move the record forward in 3 separate subforms on a (tab
page) within my main form, but when is 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)

If you have 3 forms linked to the same record, you have a potential
conflict. You might be able to solve your problem with a me.refresh
command after each form saves to a record, or set the record source for
2 of the forms temporarily to an "empty" (double quotes) while saving
the record from the 3rd form. Then set recordsource back to original
value. You can run one macro or one procedure to save a record from
each form, in sequence.

Hope this helps.

 

[Guest]

Hello Maxi,

I'm a little confused; the form is 'open' in the sense that it is always
present' on my main form within a tabbed page. Though it is not a subform. I
can just use the form as intended.