activating record selector after re-query

[smurf01]

I have a subform that is requeried from a combobox on the main form, once the requery is done I then click the record selector to requery another subform. Is there anyway to simulate that "click" by code. Once the first record is "clicked" i have it set up so that the users can use the up and down arrows to move through the records which then also requeries the second subform using the Keyup event

Regards

Paul

 

[smurf01]

OK, I have worked out that by pressing "Shift + Spacebar" this activates the first record, can anyone out there explain the correct syntax to SendKeys via VBA. I have this line of code below which does not work

SendKeys "(vbKeyShift+vbKeySpace,False)"

Regards

Paul