subform updating

[Megan Flaherty via AccessMonster.com]

I have a customer form with a subform linked by an id. I want to perform an
action on the subform when I navigate thru the customer using navigation
buttons.
where would i put the event. I have some unbound fields on my subform that
don't update when navigating thru, only on form load.
Is there a way to do that? The linked fields of course update.
I know I need to do the update but can't figure out where to put the event.
suggestions?

 

[John Webb via AccessMonster.com]

Hi,

Place the code to update the subform on the parent forms Change event.
This event takes place whenever the form changes record.

Hope that helps

John Webb

 

[Megan Flaherty via AccessMonster.com]

Thanks.
I didn't think there was a change on the form level. I'm going to try
putting it on the account ID which is an autonumber to see if that will do
it. What do you think?
Just in case - Any other suggestions?

 

[John Webb via AccessMonster.com]

There definitely is a change event at form level, and as long as the form
is bound to a data source, it will work attaching it to that event.

 

[Megan Flaherty via AccessMonster.com]

ok great thanks.
that's good because in case they don't want to change the main record.
i have to do a lookup once it changes - right now it's a manual click a
button and nobody likes it.
thanks!

 

[John Webb via AccessMonster.com]

Oops, I meant form Current event, not change.

My mistake - too tired!