Tricky one...â€Selectâ€

[Peter]

Hi all, i wish to solve the following,,
From a continuous pop up form B...i want to select some records (unbound
check box) and populate
the selected records [Bananas] and [Kilogram] in the consternated textbox
[Fruit_Basket] in the open form A...
What code do i use in the onclick event of a command button?
Example. Of record 1-10 i want to select records 4.5.6 and seven, and
“transfer†the data to one single field in Form A...

Grateful for all suggestions, Thanks!

 

[Arvin Meyer [MVP]]

This may be helpful:

http://www.mvps.org/access/modules/mdl0004.htm

 

[Linq Adams via AccessMonster.com]

The link Arvin gave you may help you reach your goal, although doing this
violates the concept of "atomic" data, i.e. one piece and only one piece of
data per field, but you need to understand that

"From a continuous pop up form B...i want to select some records (unbound
check box) and populate"

isn't possible. If the checkbox you want to use to designate selected records
in Form B is UNBOUND, the when you tick one checkbox in one record, all
checkboxes in all records will be ticked! That's the way unbound controls
work in Continuous (and Datasheet) forms. If you only want the checkboxes in
certain records to be ticked they'll have to be bound to the record n the
underlying table. .

 

[Peter]

Arvin and Linq, I thank you both for showing mw the "path"..very usefull
indeed..this is very interesting

Thanks!

 

[Marshall Barton]

"From a continuous pop up form B...i want to select some records (unbound
check box) and populate"

isn't possible. If the checkbox you want to use to designate selected records
in Form B is UNBOUND, the when you tick one checkbox in one record, all
checkboxes in all records will be ticked! That's the way unbound controls
work in Continuous (and Datasheet) forms. If you only want the checkboxes in
certain records to be ticked they'll have to be bound to the record n the
underlying table. .

Actually, it is possible by using an unbound check box and a
little code. See Albert's Multi Select Example at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Peter]

Yes..now i understand...

Form B is based on Table B, originally only with three fields.
Field A is related to Field A in Form/Table A were table A is the ONE to Many
...all i need to do is to add a Yes/No field to Table B..by ticking/Yes i
will then select the "Atomic" data,,,in this case [Bananas] and
[kilograms]...by clikcing on the command button...Ok..will look into the
Northwind sollution

Many thanks!

 

[Tom van Stiphout]

On Mon, 03 May 2010 17:31:29 -0500, Marshall Barton

Possible, but I wouldn't recommend it given the excellent
alternatives.

-Tom.
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

The link Arvin gave you may help you reach your goal, although doing this
violates the concept of "atomic" data, i.e. one piece and only one piece
of
data per field, but you need to understand that

It does if you're saving the records, instead of just returning and
displaying them. Since there wasn't any reason given , I assumed that the
data was to be displayed. There isn't any reason to store the same data
multiple times anyway.