I have an entry form with a display only subform both having the same Record Source. The fields on the main form are bound but loaded with VBA Statements in the LOAD from the calling form.
It appears to load perfectly and functions correctly until I click on the scrollbar when there are too many record for the screen. Then it appears to load the most recent record into the main form fields.
I have tried putting debug statements into every possible function on the form, and forced a module into the LOAD on the subform. However, when I click on the scrollbar, it doesn't go to debug, but the Main Form fields change.
What actually happens when a ScrollBar is clicked? Can I use a subform and a form over the same table/query?
My original purpose in setting this form up this way, was to allow viewing but not changing of previous records, and still allow entry of new records on the same screen. Scrolling to the end of a subform to enter a new record seemed awkward. Any suggestions?
It appears to load perfectly and functions correctly until I click on the scrollbar when there are too many record for the screen. Then it appears to load the most recent record into the main form fields.
I have tried putting debug statements into every possible function on the form, and forced a module into the LOAD on the subform. However, when I click on the scrollbar, it doesn't go to debug, but the Main Form fields change.
What actually happens when a ScrollBar is clicked? Can I use a subform and a form over the same table/query?
My original purpose in setting this form up this way, was to allow viewing but not changing of previous records, and still allow entry of new records on the same screen. Scrolling to the end of a subform to enter a new record seemed awkward. Any suggestions?
