| View previous topic :: View next topic |
| Author |
Message |
zen17120
Newbie
Joined: 12 Feb 2004
Posts: 4
|
 Posted: Feb 12th, 2004 07:58 PM Post subject: Populating Combo Box |
 |
|
Hi
i have 2 combo boxes 1 named cmbtown the other cmbmovies.
i also have a table named town and a seperate table for each town (e.g. manchester, london ) which has all the movies listed. i have a DAO data control linked to the table town and 1 linked to each of the the other tables.
i am trying to get it so when i select a town (e.g. manchester) in combo1, combo2 lists all the movies available in that town.
if anyone can help plz post up.
cheers
jamie
_________________
Jamie
E-mail - zen17120@zen.co.uk
Msn - Finland11@hotmail.com
Fastpay - zen17120@zen.co.uk |
|
| Back to top |
|
Avis
Junior Poster
Joined: 07 Oct 2003
Posts: 510
Location: India
|
|
| Back to top |
|
zen17120
Newbie
Joined: 12 Feb 2004
Posts: 4
|
|
| Back to top |
|
zen17120
Newbie
Joined: 12 Feb 2004
Posts: 4
|
| Posted: Feb 16th, 2004 04:55 PM Post subject: |
|
|
thats sort of what i wanted but the data i wanted in combo box 2 is in a totally different table than the data in combo box 1.
i also need it so the table which populates combo box 2, depends on what is select in combo. (e.g. if manchester is selected in combo 1, then combo box 2 is filled with a list of films that are available in manchester.)
if anyone is able to help plz do
cheers
_________________
Jamie
E-mail - zen17120@zen.co.uk
Msn - Finland11@hotmail.com
Fastpay - zen17120@zen.co.uk |
|
| Back to top |
|
Avis
Junior Poster
Joined: 07 Oct 2003
Posts: 510
Location: India
|
|
| Back to top |
|
Avis
Junior Poster
Joined: 07 Oct 2003
Posts: 510
Location: India
|
|
| Back to top |
|
zen17120
Newbie
Joined: 12 Feb 2004
Posts: 4
|
|
| Back to top |
|
|
