Using MS Access/MS access Query issue


Hi Scott

I have a split access DB and on the front end I have a navigation form that has a few tabs - 1 tab opens a tabbed subform (based on a select query) holding various types of information about current clients of our service.  I have created another tab in the navigation form where I want to be able to access the same type of information about non-current clients.  I thought if I duplicated the tabbed subform - renamed it and created a new query that selects only exited clients and attach it to my new tab this would be an easy way of achieving this but what is happening is if I change the query on the duplicated tabbed subform (non-current clients) it changes the query on the current clients and visa versa.  If I change one it automatically changes the other.  It also seems to be causing the app to crash.  I am a very random user of access and not sure what I am doing wrong - not sure if you can get a clear picture of what I am trying to explain so happy to provide more info if need be.

I have not used Navigation forms. So I'm not sure if that is affecting this. I've done pretty much the same thing, copy a subform, rename it, then change the Recordsource and its worked for me.

Double check the Source of the subform control, make sure its the right form. If you can't get it, then open a blank form, copy all the controls from the original subform and select the correct query as the Recordsource.

Hope this helps,

Using MS Access

All Answers

Answers by Expert:

Ask Experts




I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.


I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Brooklyn College BA

©2017 All rights reserved.