Problems posting a .value to a ComboBox

[JB510]

​I have a combobox:

Name: NCRcbx
Control Source: NCRcbx
Column count: 2
Bound Column: 1

Row Source: #SELECT [NCRT].[NCRID], [NCRT].[NCRNumber] FROM NCRT ORDER BY [NCRNumber]; #
Enabled: Yes
Limit to List: Yes
Inherit Value List: Yes
Show Only Row Source Value: No
Locked: No


etc..

NCRID would be like 486 and NCRNumber would be like "NCR23015".
I can click on the combo box and find that same record but cannot write it manually.

I tried

NCRcbx.Value = NCRID

but it says I can't assign a value to that object.
Help??

[Bob Fitz]

You don't tell us what NCRID is you could try:

NCRcbx = NCRID

[JB510]

You don't tell us what NCRID is you could try:

NCRcbx = NCRID

NCRID is a numerical value of 486
NCRNumber is a string value.

[Gicu]

You are not being very clear, I assume you are hiding the first column and just displaying the NCRNumber? If that's the case try using a dLookup:

Me.cboNCR=dLookup("NCRID","NCRT","NCRNumber='" & ME.NCRNumber & "'") 'adjust for your control names

Cheers,

[JB510]

Thanks for the tips guys..
I figured it out. (Sorry I'm still kind of new to this..)
My Table has two fields in it - NCRID and NCRNumber where NCRID was keyed.
Values were like (example)
NCRID NCRNumber
485 RMA49123
486 RMA49124
etc..
I had the Combobox Control Source as NCRID.. It was supposed to be unbound.
Linking to the control source told Access if I typed anything in it wanted it stored in NCRID (I think?)
Because NCRID is keyed, it would not allow duplicates and would not show it.
Simply deleting the combobox Control Source allowed it to work.
Please let me know if this seems correct... it's working anyway..