'Requery' moves the record back to 1st record

[jyotisb]

Hello,

I have a form which has 3 subforms based on a table with a combo box. When I select value from the combo box the data on the subform changes accordingly using the 'Requery'. However, they also show the record from the 1st value of the combo box. Is there a way I can get this solved? Please help as it's urgent. Thanks.

 

[pbaldy]

FYI I moved your thread fom the code repository. Is this what you're after?

http://www.baldyweb.com/Requery.htm