combo lists

[skaurd]

Hi

I am trying to create a combo list, but for some reason it isn't working properly. It keeps picking up the sector_id instead of the name.

Basically, in the wizard, I select the table and field I want listed in the combo list. I then select in which field I want this stored.

Each time I choose a field called sector - and each time it does show the sectors in the combo list, but when saving it stores the sector_id instead.

Does anyone know what I am doing wrong.

thanks

S

 

[SgtJarrow]

Two quick suggestions/questions...

The first is to check which of the columns in the combo box is the bound column....in the properties for the combo box there is a property called BoundColumn. Make sure it is set to the right one....I think by what you have said it should be 2.

The second is have you used any lookup wizards in the table?? In other words, can you go to the table and is the field set up like a combo box? There are many threads about this here in Tek-Tips...But it basically boils down to them causing lots of problems...

Let me know if anything else is needed It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution.

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer