Subform

[Florens]

Hi,

I have a form with 2 subforms on it. If I change a record on one of the subforms(sub1) I want my graph on sub2 to update. the name of the graph is grafiek. I tried it several lines of code for example:
me![sub2]!grafiek.requery
me![sub2].grafiek.requery
me![sub2].form.grafiek.requery
etc.

but all didn't work.
The top one did work on Access 2000, but not in Access 97.

Can anybody help me?

Florens

 

[neileg]

Where you have multiple forms, using the me shorthand can cause problems. Try spelling out the full object name in the event code.

 

[Florens]

Thanks for the reply.
But I don't really understand what you mean by "spelling out the full object name in the event code."
If my sub with the graph in it is named sub2
my sub which triggers the code is named sub1
and my mainform is named mainform

would it be
sub1.mainform.sub2.grafiek.requery?

I'll try some of it later, but I don't have internet on the computer that I'm programming on so I can't test it and post here at the same time. :-(

If I'm not going in the right direction, could you explain a bit more? I'll post again later.

Thanks again,

Florens.

 

[Rich]

Forms!MainFormName!Subform2Name.Requery