Prev: Change Required Field Property in Table
Next: preventing duplicates but not totally blocking
From: Gina Whipp on 19 Mar 2010 17:26
Glad to help...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Peter" <Peter(a)discussions.microsoft.com> wrote in message
news:C4F7AAA9-D380-4C77-B789-A1990DE15AA4(a)microsoft.com...
Hi Gina...ok..i understand ..well..perhaps better to assign the value per
record instead..you are right!

Thanks!

"Gina Whipp" wrote:

> Peter,
>
> No problem... we here all day and all night! Kinda sad really... oops,
> I
> digress... <smile>
>
> So you have this form and on the form you have a combo box and you want to
> select this combo box on 10 records and change the value... ahhh, nope,
> you
> can't do that. You'll have to either run an update query or *touch* each
> record and change the value.
>
> Did I understand you correctly?
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "Peter" <Peter(a)discussions.microsoft.com> wrote in message
> news:BAE907ED-90B4-401C-9E62-7BF85BB36EDB(a)microsoft.com...
> Hi Gina, sorry for my late reaction..
> I want to edit the value in a specific control for each record that is
> displayed in this form..the value is stored in a unbound combobox... i
> dont
> know how to start..
>
> 10 records..i want to select all 10 records and assign the control
> "fruits"
> with the value "bananas".."bananas" is selected from the unbounded combox
>
> "Gina Whipp" wrote:
>
> > Peter,
> >
> > Perhaps you mean *Select All Record*? 8Selct All* is only going to
> > select
> > the current record. However, I can't see how you are using this so if
> > the
> > answer was not what you wanted you could explain what you are trying to
> > do
> > and supply any code you are using...
> >
> > --
> > Gina Whipp
> > 2010 Microsoft MVP (Access)
> >
> > "I feel I have been denied critical, need to know, information!" -
> > Tremors
> > II
> >
> > http://www.regina-whipp.com/index_files/TipList.htm
> >
> > "Peter" <Peter(a)discussions.microsoft.com> wrote in message
> > news:EDF99379-9692-4B98-B777-4F24F0D3FD04(a)microsoft.com...
> > Hi all,
> >
> > In a continuous form I want to select all records displayed and assign a
> > specific control a value from an unbound combo box.
> >
> > I can not get the "select all to function..."
> >
> > What would be the best way around this?
> >
> > Thanks!
> >
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Change Required Field Property in Table
Next: preventing duplicates but not totally blocking