Combo box problems

[Alison via AccessMonster.com]

I have a combo box in a form pulling data from a Uses Table which then
returns the selected values to a Score Table.

I have two problems:

1) The selectable values are -

ID Use Score

1 Agricultural 3
2 Light industry 3
3 Coal yard 4
4 Animal processing 4
5 Miscellaneous 4
6 Waste station 5
7 Chemicals 5
8 Derelict 5

The column count is 2 and the bound column is 2.

When Light Industry is selected, it returns a value of 3 to the Score Table
but shows Agricultural in the combo. Similarly when Miscellaneous or Animal
Processing are selected a value of 4 is returned to the Score Table but Coal
Yard appears in the combo.

2) The scores from the Uses Table appear to be added together in the Score
Table if a field from the list is selected and then another from the list is
selected. I only want one score to be entered but the operator should be able
to change their mind and alter their selection without it being added to the
previous score.

Can anybody help me please?

Thanks

Alison

 

[KARL DEWEY]

I can not follow the data trail.

You say the combo box in a form is pulling data from a Uses Table. What
table is the combo box bound?

Where does the information for the Score come from?

 

[Alison via AccessMonster.com]

I have two tables – T_Score and T_Uses. They have a one to many relationship.

T_Score has two fields – ScoreID and UseScore. ScoreID is unique and
UseScore is obtained from T_Uses via a combo box. UseScore is not unique.
T_Uses has three fields – ScoreID, Use and UseScore. ScoreID is unique but
UseScore is not. It is a lookup table.

I also have a form – F1_Score. This has T_Score as a record source.
The combo box on this form has a row source SELECT [T_Uses].[Use], [T_Uses].
[UseScore] FROM T_ Uses; The column count is 2 and the bound column is 2.

Does this make it any clearer?