I want the Text, not the SelecteIndex

[joe_pool_is]

I have put together a small Access database for my use at work. It has two tables and an input form.

In my input form 'InHouse Unlock Charges' is a field named "Description" that I have set to a ComboBox. I am trying to populate it with another table's field called "Products.Software".

In the Form Designer, I have done this by opening the Properties box for the ComboBox and selecting the following:

Row Source Type: Table/Query
Row Source: SELECT Product.id, Product.Software FROM Product;​

When I run the form 'InHouse Unlock Charges', the ComboBox options show up correctly; however, if I try to input a new record, I get the message:

"The value you entered isn't valid for this field.
For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits."​

Click OK and the message goes away.

After entering my data (which still works), I can go back to my updated Table "InHouse Unlock Charges" and see that the 'Description' field was not updated with the Text, but rather the SelectedIndex value.

I don't want the SelectedIndex value. I want the Text. What have I done incorrect?

(database is posted here)

 

[Exodus]

In the form you have the bound colum to 1 set it to 2 this should fix the problem. Basicly you were imputing a number into a text field.

 

[joe_pool_is]

Thanks! That saved the day.