Subform Requery -HELP

brucey54

Registered User.
Local time
Today, 11:28
Joined
Jun 18, 2012
Messages
155
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:mad:
 
can you give a little more info and how it doesnt agree. ie error code etc.
 
Hi Shutzy, I think I know what the problem is!! The subform Requery works ok.
When the command button is pressed the subform is then refreshed with the correct data apart from the student name field.
The student name field is a combo box, sometimes it works ok and sometimes the student names are not displayed...
 
Quick question how do you get the combo query to requery from the command button,
I have the following code to make the subform requery
Forms![FrmSearchWard]![FrmSearchWardSubform].Requery
 

Users who are viewing this thread

Back
Top Bottom