Combo box and its source data

[davek81]

Hi All, I am using a drop down menu on a table and subsequently a form. I am using data held in a table which also holds all other drop down data for other combo boxes. However when using the drop down box I appear to be showing blank spaces, it would seem that the number of blanks is equal to the maximum record lines associated with another columns data, does anybody have a clue how to get rid of this bar having a table for each individual combo box. Many thanks

[RayMilhon]

Depends on how the table for your combo boxes is structured. For example:

You have 2 combo boxes for the sake of this discussion I'll just call them cbo1 and cbo2 Here's your tbl_data_choices
ID Type Description
1 1 Selection 1
2 1 Selection 2
3 2 Selection 3
4 2 Selection 3

Then your Row Source for cbo1 Would be Select ID, Description from tbl_data_choices where type = 1

Your Row Source for cbo2 would be Select ID, Description from tbl_data_choices where type = 2

That limits the choices to the appropriate ones for each combo box