PC Review


Reply
Thread Tools Rate Thread

Access2007 Combo Box

 
 
ALF
Guest
Posts: n/a
 
      4th Jun 2010
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
 
Reply With Quote
 
 
 
 
John W. Vinson
Guest
Posts: n/a
 
      4th Jun 2010
On Thu, 3 Jun 2010 21:20:44 -0700, ALF <(E-Mail Removed)> 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]
 
Reply With Quote
 
KARL DEWEY
Guest
Posts: n/a
 
      4th Jun 2010
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is this a bug in Access2007? Mark Andrews Microsoft Access 3 25th May 2009 10:12 AM
Relationships in Access2007 kgoo Microsoft Access Database Table Design 1 15th Oct 2008 03:12 AM
Access2007 over VPN OD Microsoft Access VBA Modules 1 22nd May 2008 10:53 AM
Help with SQL (Access2007) Rick Microsoft Access 2 27th Feb 2008 09:52 PM
Possible bug in Access2007 ADP?? =?Utf-8?B?ZmxvdXc=?= Microsoft Access ADP SQL Server 0 21st Dec 2006 09:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:49 PM.