Row Source Question

[hollyquinn]

Hi I am working with an Access 2003 VBA Application and I've run into a problem with one of the forms. I have a Combo Box that has a row source that looks like this: Crew;1;2;3;4;5;6;7; I'm not really sure what this is? It's not a table or a query. It doesn't refer to any function within the code (as far as I can tell). Unfortunately, the program isn't working so I can't get it to run and see what displays in this control. Anyone have any idea? Thanks in advance.

 

[missinglinq]

If you look at the box immediately prior to the Row Source you'll see one named

Row Source Type

and it will be set to

Value List

which is exactly what the Row Source is, a list of values the developer has assigned to the combobox. When dropped down the box will show the items:

Crew
1
2
3
4
5
6
7

 

[dkinley]

I would assume that this is a single column combo box so the items in the list would be "Crew", "1", "2", "3", ...

If you check the number of columns in the combo box property this will validate my assumption. If it is two columns then the list would be "Crew | 1", "2 | 3", ...

I would also suspect the field the control is bound to is a text field (and not a number) because the first entry "Crew" would require text even though the rest are numbers.

When you see the row source look like this, a;b;c;1;2, that suggests the designer opted to input what they wanted into the list instead of referencing a table or query.

-dK

 

[hollyquinn]

If you look at the box immediately prior to the Row Source you'll see one named

Row Source Type

and it will be set to

Value List

which is exactly what the Row Source is, a list of values the developer has assigned to the combobox. When dropped down the box will show the items:

Crew
1
2
3
4
5
6
7

Yep, that's what it is. Thanks for the help.

 

[hollyquinn]

I would assume that this is a single column combo box so the items in the list would be "Crew", "1", "2", "3", ...

If you check the number of columns in the combo box property this will validate my assumption. If it is two columns then the list would be "Crew | 1", "2 | 3", ...

I would also suspect the field the control is bound to is a text field (and not a number) because the first entry "Crew" would require text even though the rest are numbers.

When you see the row source look like this, a;b;c;1;2, that suggests the designer opted to input what they wanted into the list instead of referencing a table or query.

-dK

You are absolutely right. It does show 1 column. Thanks for your help.