Bounding a combo box to a record

S

sarchie

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...
 
S

sarchie

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...
 
L

Linq Adams via AccessMonster.com

Is your form Contuous, Datasheet or Single View?
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
Click to expand...
[quoted text clipped - 6 lines]
Please help...
Click to expand...
Click to expand...
 
S

Steve Schapel

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.
 
J

John W. Vinson

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...
Click to expand...

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]
 
Top