Combo Box Value Selection Unique to Record

[zufie]

How can I get the Value that I select using my Combo Box to be UNIQUE
(to save to ONE record)to the respective Record that I am viewing on
my Form?

At present, when I select a Value from the Combo Box this Value
displays on EACH of the 7441 records that I can view using my Form.

I know its some small detail on my Combo Box properties that I am
overlooking?

Thanks for any ideas?!

John

[fredg]

On Wed, 23 Jul 2008 11:41:21 -0700 (PDT), zufie wrote:

How can I get the Value that I select using my Combo Box to be UNIQUE
(to save to ONE record)to the respective Record that I am viewing on
my Form?

At present, when I select a Value from the Combo Box this Value
displays on EACH of the 7441 records that I can view using my Form.

I know its some small detail on my Combo Box properties that I am
overlooking?

Thanks for any ideas?!

John

The Combo box's Control Source must be set to a Field in a table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[zufie]

Created a field in table to store selections from Combo Box.

Bless you!

fredg wrote:

On Wed, 23 Jul 2008 11:41:21 -0700 (PDT), zufie wrote:

How can I get the Value that I select using my Combo Box to be UNIQUE
(to save to ONE record)to the respective Record that I am viewing on
my Form?

At present, when I select a Value from the Combo Box this Value
displays on EACH of the 7441 records that I can view using my Form.

I know its some small detail on my Combo Box properties that I am
overlooking?

Thanks for any ideas?!

John

The Combo box's Control Source must be set to a Field in a table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Mike P]

On 23 Jul, 19:41, zufie <[e-mail]:

How can I get the Value that I select using my Combo Box to be UNIQUE
(to save to ONE record)to the respective Record that I am viewing on
my Form?

At present, when I select a Value from the Combo Box this Value
displays on EACH of the 7441 records that I can view using my Form.

I know its some small detail on my Combo Box properties that I am
overlooking?

Thanks for any ideas?!

John

Beware the use of combo boxes in continuous forms.

Try setting the bound column of the combo box to the first visible
column (column widths in the format tab).

Mike P.