Continuous Forms Subform - Can't Get Off of 1st Record

[Scott1116]

My parent form has a combo box that lists documents; selection of a document from the combo box populates a continuous forms subform that has details of all the versions of the document.

Everything displays fine, and the subform selects the first record in the version list by default. When I try to select another record, though, the subform reselects the first. This happens whether I select the record by using the record selector button on the side of the form or the controls on the bottom.

The form has a load event that makes a couple of controls invisible -- I've tried disabling that to no avail.

I've tried creating a click event for the form with the following code to enforce selection of the new record:

'Private Sub form_click()
'Dim lngPosition As Long
'lngPosition = Me.CurrentRecord ' capture index position of record currently Selected
'Debug.Print lngPosition
'Me.Form.Recordset.Move lngPosition
'End Sub

I would be grateful for anyone's ideas, as I'm out of my own.

 

[dhookom]

It sournds like you might have code that requeries the subform or some other action.

Duane
Hook'D on Access
MS Access MVP

 

[Scott1116]

Oops -- should have addressed that in my first post.

The subform has controls with click events that requery other controls in the subform. I tried commenting out that out, and I'm still getting the problem.

The combo box of my master form has an After Update event that resets where clause of the rowsource of the subform and does a requery. I haven't done anything with that, but I can't see how that could be the source.

 

[dhookom]

I haven't done anything with that

Try comment it out since this type of code if called would result in your issue.

Duane
Hook'D on Access
MS Access MVP

 

[Scott1116]

It's persisting even after commenting out the sub.

 

[Scott1116]

I've developed a new subform, and the new one doesn't have a problem. Thank you for helping me troubleshoot.