I have a mainform (Clients) with a listbox (Projects) and a subform (Contacts). The subform is one-to-many with the mainform record. I have my own navigate buttons on the subform to move between records using Recordsetclone and Bookmarks and requerying the mainform listbox after each move. The recordsource for the listbox on the mainform shows all Projects found for a Client and flagged YES in another column, where the Project refers to the Contact/Client being viewed.
The original database was written in Access 2000 frontend/backend with an autoexec macro to kick start the main menu form. The form with the problem works perfectly in Access 2000 however problems are experienced in Access 2007, in compatiblity mode or a converted database.
The problem is when I requery the listbox when moving between the subform Contacts from anywhere in any module, the listbox requeries and so does the subform and therefore the subform quickly moves to the next record and then back to the first.
To test, I removed the requery from the subform code so that it moves between the records correctly, then added a command button on the mainform and in its OnClick I requeried the listbox, the listbox is requeried and so is the subform!
Curiously, the mainform when opened directly from the database container does work correctly.
Any ideas please?
The original database was written in Access 2000 frontend/backend with an autoexec macro to kick start the main menu form. The form with the problem works perfectly in Access 2000 however problems are experienced in Access 2007, in compatiblity mode or a converted database.
The problem is when I requery the listbox when moving between the subform Contacts from anywhere in any module, the listbox requeries and so does the subform and therefore the subform quickly moves to the next record and then back to the first.
To test, I removed the requery from the subform code so that it moves between the records correctly, then added a command button on the mainform and in its OnClick I requeried the listbox, the listbox is requeried and so is the subform!
Curiously, the mainform when opened directly from the database container does work correctly.
Any ideas please?
