Combo Box non bound output to table

[burnsey]

Hi there I'm an Access novice so please bare with me.
I am updating an existing Access Database.

The existing field 'Steady Arm' in existing 'Structures' table can be one of 4 numbers 0,900,1100,1640, and these are dependent upon the 'RegAlloc' of which there are 34 types.

I have created a combo box 'RegAllocCombo' in a form which looks at a new table 'Registration' with 4 columns ID, RegAlloc, Brace, SteadyArm.

I have bound column 0 (ID), this is the only way I can get the combo box to work as there are multiple SteadyArm values which are the same.
I have set the column width 0,2,0,0 to show the RegAlloc as the drop down selection.

I have the Control Source set to Steady Arm, but all I get in the table is the ID number, I would like it to show the value SteadyArm.

I've tried various things, such as Event - After update, =[Steady Arm]=[RegAllocCombo].column(2) and various combinations but no joy.

Any Ideas ?
Thanks Paul

[NTC]

not exactly a novice situation.

I believe all you need to do is change the bound field. You say it only works if bound to ID - and that's a little confusing as to what you mean......

[burnsey]

Thanks for your reply, if I use the steady arm column as the bound column, the combo box drop down will not work correctly, it will allow me to select some but not all RegAlloc values, I assume because the SteadyArm values are not unique, i.e. several 1100,900 etc.

A bit stuck really.

Example from registration table

ID RegAlloc Brace SteadyArm
1 A99/051/001 No 1100
2 A99/051/002 No 900
3 A99/051/003 No 1640
4 A99/051/004 Yes 1100
5 A99/051/005 Yes 900
6 A99/051/006 Yes 1640
7 A99/052/001 No 1100
8 A99/052/002 No 900
9 A99/052/003 No 1640
10 A99/052/004 No 1100
11 A99/052/005 No 900
12 A99/052/006 No 1640
13 A99/053/001 No 1100
14 A99/054/001 No 0
15 A99/054/002 Yes 0

[NTC]

not sure I fully understand - - but for a sanity check I would temporarily make all your column widths something so you can view all the data - - which should then allow you to be sure you are selecting the correct value.......and verify that everything is working...... at that point you can then return some back to 0 width if you don't need to see the column to aid in selecting the correct value.....