re-setting record selector 1

[smurf01]

I have a form that is requeried from a combo box, the amount of records can vary for each requery. If I have used the record selector and let's say it is showing as row 5 selected when I do a requery I would like the record selector to default back to the first row. is this possible

Regards

Paul

 

[KenReay]

Hi

One of several ways to do this

Me.RecordsetClone.MoveFirst
me.Bookmark = me.recordsetclone.bookmark

after the requery statement

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[smurf01]

Ken,
I am doing the requery statement from another form(frmFluteTypePapers) to this subform as shown below and I am getting an invalid reference error when I try to use it

Private Sub cmbOuterLiner_AfterUpdate()
Me![frmFTPResults].Requery
End Sub

Regards

Paul

 

[smurf01]

Ken,
My thanks for your help the problem was the way i was trying to do the requery. All is well now

:-D [ :-D

Regards

Paul