By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,189 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Combo Box Value Selection Unique to Record

P: n/a
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

Jul 23 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Jul 23 '08 #2

P: n/a
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
Jul 23 '08 #3

P: n/a
On 23 Jul, 19:41, zufie <john.marru...@illinois.govwrote:
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.
Jul 24 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.