Solved

Combo Box Selection to limit display in text box

Posted on 2011-03-02
6
300 Views
Last Modified: 2012-06-27
Hi Experts,

Can someone help me with having only the details section in the form updated based on the selection made in the combo box

i have attached a copy of the db. Example if i select state as "AL" in the combo box i should see result in the details tab as "8789", "92323" and "8979" and then when i select jurisdiction as "KJKJJKL" then i should only see "8979" in the details section.

You help on this is appreciated.

Thanks,
Nod
test.accdb
0
Comment
Question by:Saichand
  • 3
  • 2
6 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 total points
ID: 35025836
I may suggest to create 2 subforms. One subform must be sourced from a query that in a Where Clause you may put like Forms!frmYourParentForm!cboYourCombo1.

The other subform source is also a query and the Where clause would be Forms!frmYourParentForm!cboYourCombo1 And Forms!frmYourParentForm!cboYourCombo2.

On the After Update Event of your combo boxes, you need to requery the 2 subforms as:

Me.sfrmForm1. Requery
Me.sfrmForm2. Requery


Sincerely,
Ed
0
 

Author Comment

by:Saichand
ID: 35028463
the default view of my form is continuous. do you think it would work?
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35028634
Use the Single Form property of your parent/main form.

Ed
0
 

Author Comment

by:Saichand
ID: 35028673
correct me if i am wrong and let me know if i would get the list of accounts like i want in the details section
0
 

Author Closing Comment

by:Saichand
ID: 35120914
The sugesstion helped me resolve the issue
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question