Form won't update

[Tanya]

Hi I have a form with multiple subforms.

The main form frmclasses
First Tab frmAtt
then subfrmAttClassList which when a student is selected updates subfrmAttComments [This works fine]
I am also attempting to run another subform off a query and have it updated when a student is selected but this is not happening. I cannot understand why the child\Master settings are not working. Perhaps I have too many subforms?

Any suggestions appreciated.

cheers
Tanya

 

[jal]

Hi I have a form with multiple subforms.

The main form frmclasses
First Tab frmAtt
then subfrmAttClassList which when a student is selected updates subfrmAttComments [This works fine]
I am also attempting to run another subform off a query and have it updated when a student is selected but this is not happening. I cannot understand why the child\Master settings are not working. Perhaps I have too many subforms?

Any suggestions appreciated.

cheers
Tanya

Care to be more specific? I can't even figure out which "subform" and "query" you have in mind. (I suppose it doesn't matter since I probably wouldn't know how to help you, anyway).

 

[Tanya]

That is why I attached a copy of the db! To open on the form in question.

 

[Tanya]

Ok, I have found the solution, for anyone that may be interested. I unbound the text boxes on the subform in question with the statistics. I think set up a studentclassIDLink textbox with which I could link the student and update the statistics by using the following line of code:

Forms!frmClasses!frmAtt!frmqryAttendanceSub4.Form.Refresh

Cheers
Tanya

 

[jal]

That is why I attached a copy of the db! To open on the form in question.

Tanya, that form has a tab control with about five tabs and eight subforms. Things become a little easier if you you make it VERY CLEAR where to start, and where the problem is. As it is, I'm almost out of time this morning.

Had you been more clear the first time (or the second), I might could have used my time to your advantage.

 

[Tanya]

I aplogise for not making myself clearer. I guess I tend to get a little caught up and too focussed on the problem. I thought with the copy I provided which opened on the form and tab in question it would be clear what I was trying to achieve.

As I mentioned moments before you posted, I have now solved my problem which I have spent 2 days on. Thank you for you time.

Regards
Tanya