Jonathan Suthard
Registered User.
- Local time
- Yesterday, 23:42
- Joined
- May 17, 2018
- Messages
- 12
Hello,
I have a form that is used to populate JROTC Cadet data. This form uses combo boxes to select a predetermined value. I have 5 different combo boxes and all of them are working fine except for the last one.
This combo box allows selection of the number of years a cadet has been in the program...1st, 2nd, 3rd or 4th. The ID for each of these records happens to correspond to the numerical value...i.e. 1 = 1st, 2 = 2nd and so on.
The issue is I am getting the ID number instead of the desired 1st, 2nd, 3rd or 4th text entry.
Here is the current set up from the property sheet:
Selection type: Combo Box
cboYearInProgram
Data Tab
Control Source: Year in Corps(this is the table name for where the data is that I want)
Row Source: SELECT [Year in Corps].[ID], [Year in Corps].[Year In Corps] FROM [Year in Corps];
Row Source Type: Table/Query
Bound Column: 1
Format Tab:
Column count: 2
Column widths: 1",2" (have changed this to reflect 0",2" with no change)
So needless to say I am stumped...
For comparison here is another setup that is working perfectly on the same form...
cboPositionInCorps
Data Tab:
Selection type: Combo Box
cboPositionInCorps
Control Source: Position in Corps
Row Source: SELECT Position_In_Corps.Position FROM Position_In_Corps;
Row Source Type: Table/Query
Bound Column: 1
Format Tab:
Column count: 2
Column widths: 1",2"
This one works great...
I have a form that is used to populate JROTC Cadet data. This form uses combo boxes to select a predetermined value. I have 5 different combo boxes and all of them are working fine except for the last one.
This combo box allows selection of the number of years a cadet has been in the program...1st, 2nd, 3rd or 4th. The ID for each of these records happens to correspond to the numerical value...i.e. 1 = 1st, 2 = 2nd and so on.
The issue is I am getting the ID number instead of the desired 1st, 2nd, 3rd or 4th text entry.
Here is the current set up from the property sheet:
Selection type: Combo Box
cboYearInProgram
Data Tab
Control Source: Year in Corps(this is the table name for where the data is that I want)
Row Source: SELECT [Year in Corps].[ID], [Year in Corps].[Year In Corps] FROM [Year in Corps];
Row Source Type: Table/Query
Bound Column: 1
Format Tab:
Column count: 2
Column widths: 1",2" (have changed this to reflect 0",2" with no change)
So needless to say I am stumped...
For comparison here is another setup that is working perfectly on the same form...
cboPositionInCorps
Data Tab:
Selection type: Combo Box
cboPositionInCorps
Control Source: Position in Corps
Row Source: SELECT Position_In_Corps.Position FROM Position_In_Corps;
Row Source Type: Table/Query
Bound Column: 1
Format Tab:
Column count: 2
Column widths: 1",2"
This one works great...