Referencing a form in a subform

[161]

Hello, and thank you for checking out my post.



I currently have a form (which I use to input data into my tables)
Next to it, I have a subform, which uses a few simple dlookup functions to spit out some important end-result values as a FYI to the user.

It is reporting the correct values for the first entry in the form, however I want it to update as I scroll through different entries. Does anyone have any ideas how to "refresh" the subform every time I go to a new entry? Is there a way to reference the "currently being viewed" entry on the form?

[ajetrumpet]

use the "current" event. and if needed, check for "me.newrecord". that's not necessary, as the current event only runs once (I think), right when you request it.

do you still want to know how to reference a control on the main form? you do it like so (in code):

me.parent.controlname

[161]

I'm currently using the "currentevent" under the property tab of the subform, to re-open the subform every time I go to a new entry. It seems to re-open, but the subform re-opens to the first entry each time. Any ideas how I can make this variable with the data open in the main form?

[ajetrumpet]

I'm currently using the "currentevent" under the property tab of the subform, to re-open the subform every time I go to a new entry. It seems to re-open, but the subform re-opens to the first entry each time. Any ideas how I can make this variable with the data open in the main form?

whats the code

and there is no such thing as "reopening". don't know what you mean really