Prev: Access as a Front-End
Next: VBA conditional formatting
From: ALF on 4 Jun 2010 00:20
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
From: John W. Vinson on 4 Jun 2010 01:16
On Thu, 3 Jun 2010 21:20:44 -0700, ALF <ALF(a)discussions.microsoft.com> 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]
From: KARL DEWEY on 4 Jun 2010 01:56
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
 | 
Pages: 1
Prev: Access as a Front-End
Next: VBA conditional formatting