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

 

[Peter]

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

Thanks!

 

[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.