Get Subform to point at first record

[jpkeller55]

I have a form (frmQuestionDetail) with a subform (frmQandRsubform) that opens in Datasheet view. The subform is opening with the record indicator pointing to the New Record line. How can I get the pointer on the subform to show at the first record instead of new record?

[pbaldy]

Does the subform show the existing records? The behavior you desire is what should happen by default, as long as the data entry property of the form is not set to Yes. If that property is No, then I suspect some code or macro is running when the form opens to move to a new record. Check the load and open events.

[jpkeller55]

Well, I feel foolish on this as I did have code written earlier to open the form at a new record. I removed the code and now it works. I had forgotten I had put that code in...wow, that is disturbing!

[pbaldy]

We've all done it at one time or another!