Prev: MS-Access 2007
Next: Activating Office 2007
From: Lovespar on 23 Feb 2010 15:43
I am trying to use a form to edit information in a table. I have an unbound
field to search for records by, working fine. But when I tried to put in some
combo boxes so that editing fields would be easier, the data in those fields
did not change when I changed the records. I must not have something right.
Some of the fields will be filled in, but some of them will not depending on
the record so I want the record to reflect what has already been entered.
thanks in advance
From: Armen Stein on 23 Feb 2010 15:57
On Tue, 23 Feb 2010 12:43:01 -0800, Lovespar
<Lovespar(a)discussions.microsoft.com> wrote:

>But when I tried to put in some
>combo boxes so that editing fields would be easier, the data in those fields
>did not change when I changed the records. I must not have something right.
>Some of the fields will be filled in, but some of them will not depending on
>the record so I want the record to reflect what has already been entered.

Open the properties for the combobox. On the Data tab, look at the
ControlSource property. It should be set to a fieldname from your
form's recordset. Yours sound like they are unbound, meaning that the
data is just on the form and isn't attached to the underlying records.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

From: Lovespar on 24 Feb 2010 09:03


"Armen Stein" wrote:

> On Tue, 23 Feb 2010 12:43:01 -0800, Lovespar
> <Lovespar(a)discussions.microsoft.com> wrote:
>
> >But when I tried to put in some
> >combo boxes so that editing fields would be easier, the data in those fields
> >did not change when I changed the records. I must not have something right.
> >Some of the fields will be filled in, but some of them will not depending on
> >the record so I want the record to reflect what has already been entered.
>
> Open the properties for the combobox. On the Data tab, look at the
> ControlSource property. It should be set to a fieldname from your
> form's recordset. Yours sound like they are unbound, meaning that the
> data is just on the form and isn't attached to the underlying records.
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
> Thanks, it works now!
>
From: De Jager on 13 Mar 2010 13:02

"Lovespar" <Lovespar(a)discussions.microsoft.com> wrote in message
news:5E67B026-A6EE-46A5-A6C9-A160E0A473DD(a)microsoft.com...
>I am trying to use a form to edit information in a table. I have an unbound
> field to search for records by, working fine. But when I tried to put in
> some
> combo boxes so that editing fields would be easier, the data in those
> fields
> did not change when I changed the records. I must not have something
> right.
> Some of the fields will be filled in, but some of them will not depending
> on
> the record so I want the record to reflect what has already been entered.
> thanks in advance

 | 
Pages: 1
Prev: MS-Access 2007
Next: Activating Office 2007