drop down boxes

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

I have a problem that at the moment in one combo box there
is over 360 options to select ie every local authority in
UK which seems ridiculous.

What i would like is to first

click on a arrow and select "Greater London"

I would then like to be presented with all the areas
within Greater London such
as "Bromley" "Brent" "Camden"etc.

However i also need to do this for the other nine regions
such as North East, North West etc

I probably think this is a hard task do carry out if at
all possible but i would appreciate any help. even better
if i can be done without programming i would be very
grateful.


thanks for any help offered
 
Ian,
I would create a table with 2 fields...
[Area] [LocalAuthority].
Greater London Bromley
Greater London Brent
Greater London Camden etc.. etc...
Populate Combo1 (ex. cboArea) with the Area column. Use Totals in this
combo query and group on Area, which will yield just one instance of Greater
London and other Areas to choose from.

Populate Combo2 (ex. cboAuth) with LocalAuthority AND Area, (Area can be
hidden) but in the query for this combo, place the following criteria in the
[Area] Column
= Forms!frmYourFormName!cboArea

Now you can select your Area in cboArea, and cboLocalAuthority will only
display those records associated with Greater London. You're using cboArea
to filter the results of cboAuthority.
 
Hi Al,

thanks for the help.

I am quite in experienced on access so i was wondering
could you explain it all in as simple terms as possible as
i still found that quite confusing ie. step by step if
possible

-----Original Message-----
Ian,
I would create a table with 2 fields...
[Area] [LocalAuthority].
Greater London Bromley
Greater London Brent
Greater London Camden etc.. etc...
Populate Combo1 (ex. cboArea) with the Area column. Use Totals in this
combo query and group on Area, which will yield just one instance of Greater
London and other Areas to choose from.

Populate Combo2 (ex. cboAuth) with LocalAuthority AND Area, (Area can be
hidden) but in the query for this combo, place the following criteria in the
[Area] Column
= Forms!frmYourFormName!cboArea

Now you can select your Area in cboArea, and cboLocalAuthority will only
display those records associated with Greater London. You're using cboArea
to filter the results of cboAuthority.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH







I have a problem that at the moment in one combo box there
is over 360 options to select ie every local authority in
UK which seems ridiculous.

What i would like is to first

click on a arrow and select "Greater London"

I would then like to be presented with all the areas
within Greater London such
as "Bromley" "Brent" "Camden"etc.

However i also need to do this for the other nine regions
such as North East, North West etc

I probably think this is a hard task do carry out if at
all possible but i would appreciate any help. even better
if i can be done without programming i would be very
grateful.


thanks for any help offered
Click to expand...


.
Click to expand...
 
Ian,
It would take forever to explain all the "details."
Send me your email address, and I'll send a liitle mdb file that shows
how to do it.
*** Please disguise your address **** like...
example
(e-mail address removed)
to...
(e-mail address removed)
Or use a throw-away email address. Those damn spammers!
I'll keep an eye out for your reply... and... repost your question if we
get disconnected on this thread.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH


ian for attention of AL CAMPAGNA said:
Hi Al,

thanks for the help.

I am quite in experienced on access so i was wondering
could you explain it all in as simple terms as possible as
i still found that quite confusing ie. step by step if
possible

-----Original Message-----
Ian,
I would create a table with 2 fields...
[Area] [LocalAuthority].
Greater London Bromley
Greater London Brent
Greater London Camden etc.. etc...
Populate Combo1 (ex. cboArea) with the Area column. Use Totals in this
combo query and group on Area, which will yield just one instance of Greater
London and other Areas to choose from.

Populate Combo2 (ex. cboAuth) with LocalAuthority AND Area, (Area can be
hidden) but in the query for this combo, place the following criteria in the
[Area] Column
= Forms!frmYourFormName!cboArea

Now you can select your Area in cboArea, and cboLocalAuthority will only
display those records associated with Greater London. You're using cboArea
to filter the results of cboAuthority.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH







I have a problem that at the moment in one combo box there
is over 360 options to select ie every local authority in
UK which seems ridiculous.

What i would like is to first

click on a arrow and select "Greater London"

I would then like to be presented with all the areas
within Greater London such
as "Bromley" "Brent" "Camden"etc.

However i also need to do this for the other nine regions
such as North East, North West etc

I probably think this is a hard task do carry out if at
all possible but i would appreciate any help. even better
if i can be done without programming i would be very
grateful.


thanks for any help offered
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top