Select all

[Peter]

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!

 

[Gina Whipp]

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

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!

 

[Peter]

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]

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

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

 

[Peter]

Hi Gina...ok..i understand ..well..perhaps better to assign the value per
record instead..you are right!

Thanks!

 

[Gina Whipp]

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

Hi Gina...ok..i understand ..well..perhaps better to assign the value per
record instead..you are right!

Thanks!