Subform Event Not Firing

[Hildegoat15]

Hi,

I've been searching around the forums, and I can't seem to find an answer to my problem. I have a form with a tab control on it. The first page of the tab is a client's information, and the second page contains a subform showing phone calls we've made to them. In the Current event of the subform, I have code to make some controls disabled based on the value of a few certain radio buttons. The thing is that the Current event doesnt always fire when that subform is embedded in the main form.

It works when i navigate with the subform nav buttons, but shouldn't that Current event also fire when the main form is navigated thru? i mean, the record is changing on the subform (it's a different client, so it goes to the first call of this new client), so why isn't the Current event firing?

Does anyone have any idea as to how could i get the Current event for the subform to execute when the Main navigation buttons are clicked? -Matt

http://www.ranamedical.com

 

[FoxProProgrammer]

One solution is to call the subform's On Current event from the main form's On Current event. Unless the code is really needed in the subform's On Current event, you might consider moving it to a non-event driven procedure or function and calling it when you need it. dz
dzaccess@yahoo.com

 

[Hildegoat15]

i appreciate your help, but i did a bit of research on the Requery method, and if i requery the subform in the main form's Current event, it seems to trigger the Current event of the subform. so my code looks like this (for anyone who's having the same problem as me):

Me.Parent![SubformName].Requery

thanx again for the help! -Matt

http://www.ranamedical.com