Problem with Value List

[darrrellx]

I have created a subform in an expense account database and have inserted an unbound control to distinguish between a "Cash" or "Credit" expense item.
I have made the control a combo box and in the properties, I have made the Row Source Type a Value List, and in the Row Source line, I have put
Cash;Credit.

When I try to enter this in the expense form, if I choose Cash, every record becomes Cash. If I try to change it to Credit, every record then changes to show Credit.

What am I doing wrong?

Any help would be appreciated.

Thanks

darrellx

 

[boblarson]

The problem is not in the value list, but it is in the fact that you are using an unbound combo box. You need to bind it to a field. Otherwise the combo box isn't storing the data anywhere and there's no association with the record.

 

[darrrellx]

Thanks Bob