Hi folk, I have a problem that is driving me mad!!!
1. I have a main form containing class list & date
2. The subform contains a list of students
3. The main form has 2 text boxes and a command button, the user selects class and enters the date, this information is then passed into the subform query.
4. The user clicks on the command button and the following code is executed
Forms![FrmSearchClass]![FrmSearchClassSubform].Requery
And here lies the problem sometime the subform updates no problem but sometimes is doesn’t aggreeeeeeeeeeeeeeee
1. I have a main form containing class list & date
2. The subform contains a list of students
3. The main form has 2 text boxes and a command button, the user selects class and enters the date, this information is then passed into the subform query.
4. The user clicks on the command button and the following code is executed
Forms![FrmSearchClass]![FrmSearchClassSubform].Requery
And here lies the problem sometime the subform updates no problem but sometimes is doesn’t aggreeeeeeeeeeeeeeee
