Combo Box Storing Choice in Wrong Field

[Guest]

I'm trying to do something I've done numerous times in the past, however,
it's not working properly. It's a pretty basic combo box and I used the
wizard to look up:
StudentID
StudentLastname
StudentFirstname
StudentMI

I hid the first field and sorted the lookup on last, first, and MI.
Everything works except for the fact that Access keeps trying to store the
name instead of the StudentID number in the field. This is bizarre because
I've done this so many times in the past and it always works.

Any thoughts?
Thanks

 

[fredg]

I'm trying to do something I've done numerous times in the past, however,
it's not working properly. It's a pretty basic combo box and I used the
wizard to look up:
StudentID
StudentLastname
StudentFirstname
StudentMI

I hid the first field and sorted the lookup on last, first, and MI.
Everything works except for the fact that Access keeps trying to store the
name instead of the StudentID number in the field. This is bizarre because
I've done this so many times in the past and it always works.

Any thoughts?
Thanks

On the Combo box's property sheet...
On the Format tab, set the Combo Column count property to 4
On the Data tab, set the Combo Bound Column property to 1
Set the Control Source to the StudentID field.

 

[Guest]

Hi Fred:

Thanks for the response. You wrote:

[On the Combo box's property sheet...
On the Format tab, set the Combo Column count property to 4
On the Data tab, set the Combo Bound Column property to 1
Set the Control Source to the StudentID field.]
----------------------------------------------------------------------------
I did all of the above and that's why this is such a big mystery to me. I'm
not at work so I'll have to wait until tomorrow morning to double check, but
I know for sure the column count is 4 and the Combo bound column property was
set to 1 by the wizard. In the query, StudentID is the first field.

The only place where I have some doubt is the Control Source. I'm 98% sure
it's the StudentID field but I'll definitely double check that tomorrow.

If I'm right and all 3 of the conditons you listed are in fact set as you
described, could there be another issue to examine?

Thanks,
Robert

 

[Guest]

Hi Fred:

[On the Combo box's property sheet...
On the Format tab, set the Combo Column count property to 4
On the Data tab, set the Combo Bound Column property to 1
Set the Control Source to the StudentID field.]

Hi Fred:

I double checked at work this morning and all of the above properties were
set correctly. I gave up troubleshooting and deleted the combo box. I started
again and this time everything worked properly. In retrospect, I must have
made an incorrect choice somewhere in the wizard process.

Thanks for your help.