Altering one record changes value of all in database

[Key]

Hi, looked for hours for the answer but to no avail. I have 1 table
containing customer info, one of the fields in the table is one of three
types of vehicle which is currently blank for every customer ID in the table.
The form is linked to the table and I have a list box with the three types
of Vehicle in the list. When the form is opened, all the customer details
are populated correctly and the record selector at the bottom of the screen
shows the correct amount of customers, (over 3000 so far).

The problem....
When i need to change the vehicle for a particular customer via the drop
down list, it does so correctly but when I move to the next record it
duplicates this selection.

Hope I explained clearly enough the problem.

 

[boblarson]

Are you actually sure that the listbox is bound to a field?
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Key]

Hi Bob, the text field is named "wed loc type" and the control source
property is linked to "wed loc type" which is a field in the forms record
source
"client database" table. The row source type is set as "value list" and
Bound column at "1".

 

[boblarson]

Well, not sure then. I guess if you want to remove any sensitive information
and then email it to me at accessbob [a][t]] gmail dot com then I can take a
look.
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Key]

You have mail Bob..

Just one thing, I am very much a newbie when it comes to access so it may
well be a very basic mistake that I have made so please dont assume you will
offend me by posting any other simple suggestions anybody

Well, not sure then. I guess if you want to remove any sensitive information
and then email it to me at accessbob [a][t]] gmail dot com then I can take a
look.
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

Hi Bob, the text field is named "wed loc type" and the control source
property is linked to "wed loc type" which is a field in the forms record
source
"client database" table. The row source type is set as "value list" and
Bound column at "1".

 

[boblarson]

Okay, I emailed you. The problem is that you were using a listbox control
instead of a combo box. The list box, the way you had it, was just
displaying the values available and not really selected. So, you really need
to change to a combo the way you have it and select it from it.

Also, you really should read up on NORMALIZATION as you shouldn't really be
using repeating fields like that.

Some suggested reading here:
http://support.microsoft.com/kb/283878
http://www.accessmvp.com/strive4peace/


--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

You have mail Bob..

Just one thing, I am very much a newbie when it comes to access so it may
well be a very basic mistake that I have made so please dont assume you will
offend me by posting any other simple suggestions anybody

Well, not sure then. I guess if you want to remove any sensitive information
and then email it to me at accessbob [a][t]] gmail dot com then I can take a
look.
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

Hi Bob, the text field is named "wed loc type" and the control source
property is linked to "wed loc type" which is a field in the forms record
source
"client database" table. The row source type is set as "value list" and
Bound column at "1".


:

Are you actually sure that the listbox is bound to a field?
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________


:

Hi, looked for hours for the answer but to no avail. I have 1 table
containing customer info, one of the fields in the table is one of three
types of vehicle which is currently blank for every customer ID in the table.
The form is linked to the table and I have a list box with the three types
of Vehicle in the list. When the form is opened, all the customer details
are populated correctly and the record selector at the bottom of the screen
shows the correct amount of customers, (over 3000 so far).

The problem....
When i need to change the vehicle for a particular customer via the drop
down list, it does so correctly but when I move to the next record it
duplicates this selection.

Hope I explained clearly enough the problem.

 

[Key]

Thanks Bob, works fine now.

Will be searching for Normalization later this evening as you suggested.

Many thanks

Key

Okay, I emailed you. The problem is that you were using a listbox control
instead of a combo box. The list box, the way you had it, was just
displaying the values available and not really selected. So, you really need
to change to a combo the way you have it and select it from it.

Also, you really should read up on NORMALIZATION as you shouldn't really be
using repeating fields like that.

Some suggested reading here:
http://support.microsoft.com/kb/283878
http://www.accessmvp.com/strive4peace/


--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

You have mail Bob..

Just one thing, I am very much a newbie when it comes to access so it may
well be a very basic mistake that I have made so please dont assume you will
offend me by posting any other simple suggestions anybody

Well, not sure then. I guess if you want to remove any sensitive information
and then email it to me at accessbob [a][t]] gmail dot com then I can take a
look.
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________


:

Hi Bob, the text field is named "wed loc type" and the control source
property is linked to "wed loc type" which is a field in the forms record
source
"client database" table. The row source type is set as "value list" and
Bound column at "1".


:

Are you actually sure that the listbox is bound to a field?
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________


:

Hi, looked for hours for the answer but to no avail. I have 1 table
containing customer info, one of the fields in the table is one of three
types of vehicle which is currently blank for every customer ID in the table.
The form is linked to the table and I have a list box with the three types
of Vehicle in the list. When the form is opened, all the customer details
are populated correctly and the record selector at the bottom of the screen
shows the correct amount of customers, (over 3000 so far).

The problem....
When i need to change the vehicle for a particular customer via the drop
down list, it does so correctly but when I move to the next record it
duplicates this selection.

Hope I explained clearly enough the problem.