Add a field to a linked combo box

N

Number24

I have 2 combo boxes, (ComboLocation & ComboSubLocation) ComboSubLocation
values are dependent on what is chosen in ComboLocation. However, I also
need to be able to choose "NONE" in ComboSubLocation for instances when
there is no sub location.

Can anyone help?


TIA
 
N

Number24

The problem with this is that there is a one to many relationship between the
locations and sub locations table, and the user will be adding to the tables
on a regular basis so they would also need to add "none" each time a new
location was added. I could probably add code to do this but just thought
there may be an easier way?
 
Top