ComboBox value inserting into form, but not table

[TeriCoombes]

I have a form that requires a user to select their name from a combobox before they log in data. Their name is then supposed to be added to the records they modify. In the form I have:

=Forms!frmSelectTest!cboAnalyst

which displays their name correctly. However this value is not inserted into the table. Does anyone know what I am doing wrong?

 

[Remou]

Hi
This is a bound combobox is it?

 

[TheAceMan1]

How are ya TeriCoombes . . . . .

[blue]cboAnalyst[/blue] needs to be [blue]bound to a field[/blue]. If the field doesn't exist . . . create one!

See Ya! . . . . . .

 

[TeriCoombes]

The combobox is bound to the Analyst table. And that is working correctly with the form. The problem is getting the table to take the value from the combobox.

 

[Remou]

Hi
Have you checked the Control Source in properties to make sure it is bound to the right field?

 

[TheAceMan1]

TeriCoombes . . . . . .

If you used the combobox wizard to set it up, the PK of the table is usually the first and [blue]bound column[/blue]. [purple]The bound column is what gets stored in the field[/purple] and is probably what your seeing.

[blue]Try changing the bound column property to 2.[/blue]

See Ya! . . . . . .