A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access2007 Combo Box



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 05:20 AM posted to microsoft.public.access
Alf
external usenet poster
 
Posts: 17
Default Access2007 Combo Box

Never saw this before and can't fix. I have an unbound combo box with 6
names. In the form I can choose one name. When I look at the next record it
has that name in it, the next and the next...How do I stop this? I want that
name in the current record ONLY not all of 'em.
I'm not a programmer so simple is good!
Thank you
Andrea
  #2  
Old June 4th, 2010, 06:16 AM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Access2007 Combo Box

On Thu, 3 Jun 2010 21:20:44 -0700, ALF wrote:

Never saw this before and can't fix. I have an unbound combo box with 6
names. In the form I can choose one name. When I look at the next record it
has that name in it, the next and the next...How do I stop this? I want that
name in the current record ONLY not all of 'em.
I'm not a programmer so simple is good!
Thank you
Andrea


An unbound combo box on a Continuous Form is *one combo box* - even if you see
it six or sixty times on the form.

If you want data to be associated with each record in a table, it must be *in
the table (or in a related table). A combo box on a form is not a data storage
medium.

If you want the name to be in this record and not all of them - then the combo
box MUST be bound to a field in the table.
--

John W. Vinson [MVP]
  #3  
Old June 4th, 2010, 06:56 AM posted to microsoft.public.access
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Access2007 Combo Box

Because it is 'unbound' it does not reflect data from any record.

If you were to open the table you would see that the field does not contain
data.

--
Build a little, test a little.


"ALF" wrote:

Never saw this before and can't fix. I have an unbound combo box with 6
names. In the form I can choose one name. When I look at the next record it
has that name in it, the next and the next...How do I stop this? I want that
name in the current record ONLY not all of 'em.
I'm not a programmer so simple is good!
Thank you
Andrea

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.