|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 20th, 2008, 03:16 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Multiple Combo boxes
Is it possible to synchronize 4 combo boxes? If so, would I have to create
four tables and link them? Please help, I am in a big rut...Thanks! 
|
|
#2
November 20th, 2008, 04:18 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Multiple Combo boxes
Is your question how to get a series of combo boxes to display records
dependent on a prior selection? If so, this can be done in a from with combo boxes. It can't and shouldn't be done in a report design. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Is it possible to synchronize 4 combo boxes? If so, would I have to create four tables and link them? Please help, I am in a big rut...Thanks!
|
|
#3
November 21st, 2008, 04:46 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Multiple Combo boxes
You've asked a "how" question.
My question is "what?" Why do you want to do this? What will having "4 synchronized comboboxes" allow you/your users to do? I ask, not out of idle curiosity, but because there might be other "how's" for the "what" you need to accomplish. Regards Jeff Boyce Microsoft Office/Access MVP "Mani" wrote in message news  Is it possible to synchronize 4 combo boxes? If so, would I have to create four tables and link them? Please help, I am in a big rut...Thanks!
|
|
#4
November 21st, 2008, 08:57 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Multiple Combo boxes
Please replace "shouldn't be done in a report design" with "shouldn't be done
in a table design" in my reply. -- Duane Hookom Microsoft Access MVP "Duane Hookom" wrote: Is your question how to get a series of combo boxes to display records dependent on a prior selection? If so, this can be done in a from with combo boxes. It can't and shouldn't be done in a report design. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Is it possible to synchronize 4 combo boxes? If so, would I have to create four tables and link them? Please help, I am in a big rut...Thanks!
|
|
#5
November 24th, 2008, 09:12 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Multiple Combo boxes
Ok... so I am really confused because I am trying to modify a database, so as
you know it's harder for me since I didn't develop the database and I have work around with what i have. okay.. so this is the situation I want to synchronize 4 combo boxes, but before I can do that, do I have to create four tables to link them and make somehow connect?? sorry for my lack of access terminology... I've already established 2 combo boxes already.. which worked.. now i want to do the same thing to combo 3 and 4... so in essence, i already have combo 2 which is filtered by 1, and now i want combo 3 to be filtered by 2, and combo 4 be filtered by 3. I hope that makes sense... please help. "Duane Hookom" wrote: Is your question how to get a series of combo boxes to display records dependent on a prior selection? If so, this can be done in a from with combo boxes. It can't and shouldn't be done in a report design. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Is it possible to synchronize 4 combo boxes? If so, would I have to create four tables and link them? Please help, I am in a big rut...Thanks!
|
|
#6
November 24th, 2008, 11:32 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Multiple Combo boxes
I would take the method you used for the first combo boxes and apply it to
your other combo boxes. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Ok... so I am really confused because I am trying to modify a database, so as you know it's harder for me since I didn't develop the database and I have work around with what i have. okay.. so this is the situation I want to synchronize 4 combo boxes, but before I can do that, do I have to create four tables to link them and make somehow connect?? sorry for my lack of access terminology... I've already established 2 combo boxes already.. which worked.. now i want to do the same thing to combo 3 and 4... so in essence, i already have combo 2 which is filtered by 1, and now i want combo 3 to be filtered by 2, and combo 4 be filtered by 3. I hope that makes sense... please help. "Duane Hookom" wrote: Is your question how to get a series of combo boxes to display records dependent on a prior selection? If so, this can be done in a from with combo boxes. It can't and shouldn't be done in a report design. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Is it possible to synchronize 4 combo boxes? If so, would I have to create four tables and link them? Please help, I am in a big rut...Thanks!
|
|
#7
November 25th, 2008, 03:12 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Multiple Combo boxes
So are you saying i have to create two tables and link them so i could use
them to the combo boxes?? if that's the case how?? because combo 3 will be filtered by combo 2.. and so on, so doesn't that mean i have to somehow connect or link all the tables together???? "Duane Hookom" wrote: I would take the method you used for the first combo boxes and apply it to your other combo boxes. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Ok... so I am really confused because I am trying to modify a database, so as you know it's harder for me since I didn't develop the database and I have work around with what i have. okay.. so this is the situation I want to synchronize 4 combo boxes, but before I can do that, do I have to create four tables to link them and make somehow connect?? sorry for my lack of access terminology... I've already established 2 combo boxes already.. which worked.. now i want to do the same thing to combo 3 and 4... so in essence, i already have combo 2 which is filtered by 1, and now i want combo 3 to be filtered by 2, and combo 4 be filtered by 3. I hope that makes sense... please help. "Duane Hookom" wrote: Is your question how to get a series of combo boxes to display records dependent on a prior selection? If so, this can be done in a from with combo boxes. It can't and shouldn't be done in a report design. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Is it possible to synchronize 4 combo boxes? If so, would I have to create four tables and link them? Please help, I am in a big rut...Thanks!
|
|
#8
November 25th, 2008, 04:50 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Multiple Combo boxes
Roger Carlson has a small sample database demo of cascading combo boxes at
http://www.rogersaccesslibrary.com/f...pics.asp?FID=1. This should get you on the right track. -- Duane Hookom Microsoft Access MVP "Mani" wrote: So are you saying i have to create two tables and link them so i could use them to the combo boxes?? if that's the case how?? because combo 3 will be filtered by combo 2.. and so on, so doesn't that mean i have to somehow connect or link all the tables together???? "Duane Hookom" wrote: I would take the method you used for the first combo boxes and apply it to your other combo boxes. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Ok... so I am really confused because I am trying to modify a database, so as you know it's harder for me since I didn't develop the database and I have work around with what i have. okay.. so this is the situation I want to synchronize 4 combo boxes, but before I can do that, do I have to create four tables to link them and make somehow connect?? sorry for my lack of access terminology... I've already established 2 combo boxes already.. which worked.. now i want to do the same thing to combo 3 and 4... so in essence, i already have combo 2 which is filtered by 1, and now i want combo 3 to be filtered by 2, and combo 4 be filtered by 3. I hope that makes sense... please help. "Duane Hookom" wrote: Is your question how to get a series of combo boxes to display records dependent on a prior selection? If so, this can be done in a from with combo boxes. It can't and shouldn't be done in a report design. -- Duane Hookom Microsoft Access MVP "Mani" wrote: Is it possible to synchronize 4 combo boxes? If so, would I have to create four tables and link them? Please help, I am in a big rut...Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
