List box on bound form shows no selection

[warmslime]

Hi experts, I have a simple table which lists the movies I've rent and the prices I paid. The amount field is formatted as Currency - Euro on the table level.
I've made a simple bound form with a list box that has three possible values, entered manually as a value list (this is also a validation rule on the table itself, because the field will have only one of those values on every record).
When I use it to save records, the field is populated just fine, however when I view an already saved record, it doesn't show me the amount of that record selected on the list box. It just shows the list with nothing selected


can anyone help? the combobox above it works as it should be

[ranman256]

The listbox is bound to the CONTROL SOURCE (the field to save in)
and the ROW SOURCE is set to the list of values to pick from
so,
looking at the table, are the values there?
is the listbox unlocked?
is the correct BOUND column in listbox set to the correct value?

[Micron]

You bound the form but is the listbox bound to the table field whose values you want to show?

[warmslime]

The listbox is bound to the CONTROL SOURCE (the field to save in)
and the ROW SOURCE is set to the list of values to pick from
so,
looking at the table, are the values there?
is the listbox unlocked?
is the correct BOUND column in listbox set to the correct value?

Yes to all. This form and every field in it were created by the Access wizard automatically. I also add that the form works just fine when adding a new record (that field is correctly added to the underlying table), and it even works when I select a different value in an already existing record, but it just doesn't show me the value in the table when I navigate to it.

I'll make a guess here by saying that Access doesn't play well with Currency fields with value lists on list boxes (when editing records). I suppose it doesn't try to match the value of the record to a value of the field list. I ended up working around the problem by making a separate table with two fields, an ID and amount field, and then replacing the field in the original table with its key. Then I edited the listbox to only show the second column of the table but with the ID number as the bound field. It now works fine. I'm not really upset that I had to do this, I just wonder why it works with the Number field (the "Rental duration" field in the picture) and not with the Currency field...