By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,155 Members | 2,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,155 IT Pros & Developers. It's quick & easy.

Access Subform

P: 3
Hi, I am new to Access. Can someone please help me.

Access 2000

I have a form that works. I want to add a subform based on the selection of a drop down list.
Drop down list contains A B C.
If A is selected, I want an option group to appear.
If B is selected, I want an option group separate of A option group to appear.

Can someone please assist me.

Thank you.
Sep 6 '07 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,383
Where does the subform come in?
Sep 6 '07 #2

P: 3
Maybe I am not using the right terminology. I researched a little more and I think I mean cascading Combo Boxes, not subform. I still do not totally understand how to link cascading combo boxes, so I would really appreciate any help.
Thanks.
Sep 6 '07 #3

P: 3
Here is my code

Private Sub cboModel_AfterUpdate()
On Error Resume Next
Select Case cboModel.Value
Case "A"
cboColor.RowSource = "ColorGroup1tbl"
Case "B"
cboColor.RowSource = "ColorGroup2tbl"
Case "C"
cboColor.RowSource = "ColorGroup3tbl"
End Select
End Sub
Sep 6 '07 #4

Rabbit
Expert Mod 10K+
P: 12,383
Take a look at this tutorial.
Sep 6 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.