Bounding a combo box to a record

I am trying to create a combo box or a list that the users can select from.
The list is the same for each record but I would like each selection to be
independent of the other records.

Example, I have 105 records and the user is supposed to go into their
particular record and update the status as "On Track, Off Track...." When I
tested out my combo box, I selected "on track" for my first record and all of
the other records changes to "on track".

Please help...

I have checked all of my properties and I still cannot select from my combo
box. I am working in MSAccess 2000. Please assist me...

sarchie wrote:
I am trying to create a combo box or a list that the users can select from.
The list is the same for each record but I would like each selection to be
independent of the other records.

Example, I have 105 records and the user is supposed to go into their
particular record and update the status as "On Track, Off Track...." When I
tested out my combo box, I selected "on track" for my first record and all of
the other records changes to "on track".

Please help...

Is your form Contuous, Datasheet or Single View?

sarchie wrote:
I have checked all of my properties and I still cannot select from my combo
box. I am working in MSAccess 2000. Please assist me...

I am trying to create a combo box or a list that the users can select from.
The list is the same for each record but I would like each selection to be
[quoted text clipped - 6 lines]

Please help...

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200712/1

Sarchie,

This would indicate that the combobox is unbound. That means that the
Control Source property of the combobox is blank. You need to set the
Control Source of the combobox to the name of a field in the table/query
that the form is based on, in particular the field that the Status for
each record will be recorded into. If there is currently no such field,
you will first of all need to go to the design view of the table and add
a field for this purpose.

--
Steve Schapel, Microsoft Access MVP

sarchie wrote:
I have checked all of my properties and I still cannot select from my combo
box. I am working in MSAccess 2000. Please assist me...

sarchie wrote:
I am trying to create a combo box or a list that the users can select from.
The list is the same for each record but I would like each selection to be
independent of the other records.

Example, I have 105 records and the user is supposed to go into their
particular record and update the status as "On Track, Off Track...." When I
tested out my combo box, I selected "on track" for my first record and all of
the other records changes to "on track".

Please help...

On Mon, 03 Dec 2007 19:19:45 GMT, "sarchie" u39585@uwe wrote:

I am trying to create a combo box or a list that the users can select from.
The list is the same for each record but I would like each selection to be
independent of the other records.

Example, I have 105 records and the user is supposed to go into their
particular record and update the status as "On Track, Off Track...." When I
tested out my combo box, I selected "on track" for my first record and all of
the other records changes to "on track".

Please help...

What's the Control Source property of the combo? What's the Recordsource for
the form?

It sounds like you have an unbound combo, or that you don't have a field in
the table into which to store the status.

John W. Vinson [MVP]