Problems with subforms

[5ilver]

Hi
I have a continuous subform which has 5 textboxes on each row. After the user enters a value in any one of the textboxes a function is called which uses all the data in the subform and some on the main form to calculate some results. I was just wondering what the best way is to acheive this.

At the moment I'm using the onexit event on the textboxes (which doesn't always work) and then I'm looping through the subform recordset using DAO (any other way changes the focus in the subform).

The main thing I want to achieve is to recalculate all the values whenever the user changes just one box.

 

[ajetrumpet]

sounds like you're already doing it. why doesnt the exit event always work? what goes wrong? did you try a manual button as another alternative?

 

[5ilver]

I think a manual button would be the most reliable. I was just hoping for a failsafe real time updating form really.

The exit event on a subform control doesn't seem to fire if the user clicks onto the main form background for some reason.

 

[ajetrumpet]

I think a manual button would be the most reliable. I was just hoping for a failsafe real time updating form really.

The exit event on a subform control doesn't seem to fire if the user clicks onto the main form background for some reason.

try the lostfocus() event. maybe the exit event relates to the keyboard, but not sure