Using MS Access/MS access Query issue

Advertisement


Question
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.

Answer
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,
Scott<>

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

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

Experience

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

Organizations
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

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.