From: KARL DEWEY on
It appears you did not bind the combo to a field.
Row Source is where the combo pull data from and Control Source is where it
is bound to store the data.
Bound Column is the field of Row Source that you store.

--
Build a little, test a little.


"Terri" wrote:

> Thanks for your replies, I have followed what you have both said for me to do
> and have the form now working BUT the data is duplicated on each record ie we
> change record 3 and records 1 and 2 change to match record 3, have I missed
> something on one of the settings. Thanks again for your help.
> --
> Thanks
> Terri
>
>
> "Terri" wrote:
>
> > OK here goes, hope this is clear
> >
> > I am wanting to set up a database where info is selected in one field and
> > then multiple fields are populated. EG entering username from drop down list
> > automatically fills in Name, Dept and Ext so save looking all those up each
> > time.
> >
> > In excel I would use the lookup function and put formulae in each cell.
> > Is this possible in access? Any help greatly appreciated.
> > --
> > Thanks
> > Terri
From: BruceM via AccessMonster.com on
I just realized I misunderstood what is going on. The text boxes would
either have combo box columns or query fields as their Control Source. I
somehow read unbound text boxes into the equation. My error.

To the OP, the article to which I linked in my previous posting is
interesting to know about, but does not seem to apply in this situation. The
other part, about storing historical data that is subject to change, could
apply, depending on the situation.

KARL DEWEY wrote:
>It appears you did not bind the combo to a field.
>Row Source is where the combo pull data from and Control Source is where it
>is bound to store the data.
>Bound Column is the field of Row Source that you store.
>
>> Thanks for your replies, I have followed what you have both said for me to do
>> and have the form now working BUT the data is duplicated on each record ie we
>[quoted text clipped - 10 lines]
>> > In excel I would use the lookup function and put formulae in each cell.
>> > Is this possible in access? Any help greatly appreciated.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1

From: Terri on
Thanks very much, that has now solved the problem for me - I was missing
changing the bound column selection. Thanks again for the replies.
--
Thanks
Terri


"KARL DEWEY" wrote:

> It appears you did not bind the combo to a field.
> Row Source is where the combo pull data from and Control Source is where it
> is bound to store the data.
> Bound Column is the field of Row Source that you store.
>
> --
> Build a little, test a little.
>
>
> "Terri" wrote:
>
> > Thanks for your replies, I have followed what you have both said for me to do
> > and have the form now working BUT the data is duplicated on each record ie we
> > change record 3 and records 1 and 2 change to match record 3, have I missed
> > something on one of the settings. Thanks again for your help.
> > --
> > Thanks
> > Terri
> >
> >
> > "Terri" wrote:
> >
> > > OK here goes, hope this is clear
> > >
> > > I am wanting to set up a database where info is selected in one field and
> > > then multiple fields are populated. EG entering username from drop down list
> > > automatically fills in Name, Dept and Ext so save looking all those up each
> > > time.
> > >
> > > In excel I would use the lookup function and put formulae in each cell.
> > > Is this possible in access? Any help greatly appreciated.
> > > --
> > > Thanks
> > > Terri