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

Selection - Combo Boxes

P: n/a
Rob
Hello,
I am developing an A2K application.In the subform ,I have around 4
combo boxes for Group,Division,Name and Application.The selection
criteria of each combo is narrowed based on the value of other combo
box.In fact Application is selected based on Group,Division &
Names.But in many cases there are Divisions which do not have any
Names.
I need to select Applications either on two conditions,one if Names
are available, which presently i am able to do.Another to select
Applications based on Divisions which do not have any Names.

Group----->Division------>Name
! !
! !
!--------->Application.
How to select the Rowsource of the Application based on either of the
criterias?

Thanks

Rob
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
One solution would be to write VB code for the 'on click' event of the
Division combo box. Using an If/Else structure you could set focus to the
Application combo if no name was required. If a name is required set focus
to the Name combo box. In each application it would be advisable to test
that all the required parameters were supplied.
Hugh.

"Rob" <ch*******@yahoo.com> wrote in message
news:60**************************@posting.google.c om...
Hello,
I am developing an A2K application.In the subform ,I have around 4
combo boxes for Group,Division,Name and Application.The selection
criteria of each combo is narrowed based on the value of other combo
box.In fact Application is selected based on Group,Division &
Names.But in many cases there are Divisions which do not have any
Names.
I need to select Applications either on two conditions,one if Names
are available, which presently i am able to do.Another to select
Applications based on Divisions which do not have any Names.

Group----->Division------>Name
! !
! !
!--------->Application.
How to select the Rowsource of the Application based on either of the
criterias?

Thanks

Rob

Nov 12 '05 #2

P: n/a
Ed
ch*******@yahoo.com

(The selection
criteria of each combo is narrowed based on the value of other combo
box.>
Rob


What do I need to do to make this happen in a form?

Thanks,
Ed
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.