I have some code that requires a requery of the base data of a subform. The problem is that if the subform is in a windows and the vertical scroll has been used to go to a certain record, after the update the subform jumps back to the first record. I would like to do a requery but not alter the...
Thanks,
My problem seemd to be that I didn't know what to define the record set as - DAO ADO etc.
The line
dim rs asADODB.Recordset
was the important one.
Thanks
Mark.
I have a datasheet subform on a main form. The subform records have tick box fields. When a subform tickbox is ticked, (the on click event), I want to check all other records in the subform to see if all tick boxes have been ticked, and then update the main form header record accordingly. I am...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.