Hello,
I have a subform which is bound to a query. I use an option group to change the recordsource of this query.
The user can navigate through all the records in the main form. However if you first change the recordsource by selecting "Live" or "Archived" and then navigate through the recordset of the main form using the navigation buttons then the form moves up and the "Description" control is hidden. I have tried placing an invisible dummy text box at the top of the form and setting the focus to it to stop this happening which works but the cursor then flashes at this position which looks ugly.
The 2 attached images should clarify the problem.
I would appreciate if someone could help explain why this is happening and suggest a solution.
Many thanks.
Paul