combo sort

[tubar]

I have these 100 location names which are categorized by 10 types. I would like to create a combo box listing the types…after the user selects the type… this form or another one has a list box filtered of locations only pertaining to that type…that value needs to be used to input data like an issue

Example TYPE=meeting room Location=101 user fills out information 1 burnout light in meeting room 101

 

[Kryst51]

Are these in two different tables?

Like so:

tblLocations
pkLocationID
Location
fkTypeID

tblTypes
pkTypeID
Type

Then in your relationships relate the pkTypeID in tblTypes to fkTypeID in tbllocations

If this isn't your current setup, I suggest changing it, so that what you want to achieve is a lot easier, actually, if you want to do it the way you currently have visit this thread for info.

 

[missinglinq]

The concept is called "cascading comboboxes," although the same thing can be accomplished with a ListBox with Multi-select set to None. Here a link to one tutorial on the subject http://bytes.com/topic/access/insights/605958-cascading-combo-list-boxes and you can find many others by searching on cascading comboboxes.

 

[Kryst51]

Arghh. I am thinking too slow this morning! Thanks missinglinq.

 

[tubar]

i have a location table and a location type table i also have an issues table. so when the user selects location type (meeting room) the next form should filter all locations to display just meeting rooms. when the user selects meeting room 101 then a new record in the issues table should be added for issue meeting room 101