Keep subform records visible

Topic

New Reply

Access 97. In a subform with 10 records, a button triggers a calculation on the current record. When this happens, the records “scroll” upward until the current record is at the top of the subform window, effectively hiding all previous records. I need to keep all the subform records visible.

I can use the navigation buttons to move back to the first record, but if I try in code, I’m told that the form is not open. What little piece of information do I need?

Thanks

Reply | Quote

Replies

Post the code you’re trying to use. Someone should be able to spot the problem.

Reply | Quote

I bet you are trying to address the subform directly in the Forms collection, as in “Forms!formname”, etc.

A subform is NOT an open form! That is, it is not in Forms collection. YOu must access it via the subform control on the mainform. So it would be like this:
Forms!MainformName!subformControlName.Form…..etc.

Reply | Quote

Yes, you are right! But I still don’t understand. The subform is not an open form. As a user, I can click the navigation button in the subform that will take me to the first record. In an open form, I can ask to go to the first record via code. How do I use code to go to the first record in a subform CONTROL?

Reply | Quote

I generally do it this way:
With Forms!MainFormName!subformControlName.Form
.recordsetclone.movefirst
.bookmark = .recordsetclone.bookmark
end with

Reply | Quote