but after trying out your code, i noticed that the results of the requery is lagging behind by one click. maybe i did not explain clearly. the main form i have now contains 3 subforms. 2 of the subforms is based on tables, while the third one is based on a query. the one i'm trying to requery is the third form. let's call them form A, form B, and form C.
now the situation is this, when i choose a record on form A, form B will show the related stuff of the record in form A. form C will then show the data that is related to form B.
the code that bmacr provided, does requery form C. Strangely, the data shown is not of the present selected record, but of the previous record. what i want to do is when i choose the present record, form C will show the stuff related to the present record.
Your Form C is being requeried before Form B has been updated. You should have your requery code fire some time after Form B has updated. Try putting it in Form B's After Update event, or maybe its Current event.
funny thing now is that i have to click on form B before form C can requery... any idea on how to make form C requery right after i click on form A? i think i let form B and form C display their data simultaneously is better...