Subform Current Event Not Firing

[Matty]

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?

 

[Sohaila Taravati]

Put this behinde your navigation button:

Me.Parent![SubformName].Requery

Let me if it works

 

[Matty]

Thanx for your help, but i had to modify that line of code a bit. Since i'm using the default navbar, i put it in the main form's Current event. Since using Parent doesn't really work on the main form (it gave me an error before i thought it thru lol), i just requeried the subform using this modified line:

Me![SubformName].Requery

it seems to work, but i'm sure i'll be back if my form blows up.

thanx again!