Combo Box Selection to limit display in text box

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
SaichandAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MINDSUPERBConnect With a Mentor Commented:
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
 
SaichandAuthor Commented:
the default view of my form is continuous. do you think it would work?
0
 
MINDSUPERBCommented:
Use the Single Form property of your parent/main form.

Ed
0
 
SaichandAuthor Commented:
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
 
SaichandAuthor Commented:
The sugesstion helped me resolve the issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.