subform updating

  • Thread starter Thread starter Megan Flaherty via AccessMonster.com
  • Start date Start date
M

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?
 
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
 
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?
 
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.
 
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!
 
Oops, I meant form Current event, not change.

My mistake - too tired!
 
Back
Top