I am using Access 2013. I am developing a DB based on 'Navigation Forms'.
I have a tab which opens a subform containing 'Clients'. Also in this subform is a button which uses the 'BrowseTo' to navigate to another subform (EditDiary) which opens at a record designated by the 'FullName' open at the time in the 'Client' subform. When the user has finished in the 'EditDiary' subform double clicking the FullName navigates back to the 'Client' subform at the same record.
This all works as expected except.....to navigate back to the 'Client' subform using 'BrowseTo' containing a 'Where' criteria FILTERS the 'Client' subform to just that one record. What I want to happen is to navigate to the 'Client' subform and just 'GoTo' that record without the filtering.
NB This is using the Access 2010/2013 new 'Navigation Form'
Any help appreciated
Regards
Smalty
I have a tab which opens a subform containing 'Clients'. Also in this subform is a button which uses the 'BrowseTo' to navigate to another subform (EditDiary) which opens at a record designated by the 'FullName' open at the time in the 'Client' subform. When the user has finished in the 'EditDiary' subform double clicking the FullName navigates back to the 'Client' subform at the same record.
This all works as expected except.....to navigate back to the 'Client' subform using 'BrowseTo' containing a 'Where' criteria FILTERS the 'Client' subform to just that one record. What I want to happen is to navigate to the 'Client' subform and just 'GoTo' that record without the filtering.
NB This is using the Access 2010/2013 new 'Navigation Form'
Any help appreciated
Regards
Smalty
