Concatenation

[Peter]

Hi all,
I have to tables and two form, Tbl A = Form A, Tbl B = From B. Form B is a
subform to Form A. On the “Load event†of Form B i want field “Bananas†to
become populated with data from fields “Fruitsâ€,â€Basketâ€,â€Colour†in Form A

Me![Bananas] = Forms![A].[Fruits]&â€â€&[Basket] etc.. does not function..

One way to “almost†solve this would be to build Form B on a query were I
Concatenate the fields..but I want form B to create a new record on load
(Data Entry = Yes) and the way I see it..it cannot create a new record based
on this query...

Thankful for assistance!

 

[Stefan Hoffmann]

hi Peter,

I have to tables and two form, Tbl A = Form A, Tbl B = From B. Form B is a
subform to Form A. On the “Load event†of Form B i want field “Bananas†to
become populated with data from fields “Fruitsâ€,â€Basketâ€,â€Colour†in Form A

Me![Bananas] = Forms![A].[Fruits]&â€â€&[Basket] etc.. does not function..

I'm not sure why a field "Bananas" makes sense here. If you only want to
display the information in one field, place a TextBox on your form and
set its Control Source to "=Forms![A].[Fruits] & ' ' & [Basket]".

One way to “almost†solve this would be to build Form B on a query were I
Concatenate the fields..but I want form B to create a new record on load
(Data Entry = Yes) and the way I see it..it cannot create a new record based
on this query...

In most cases like this I prefer two forms: one for displaying the data
and one for data entry.


mfG
--> stefan <--

 

[Peter]

You are correct Stefan..i will choose that path, Thanks!

hi Peter,

I have to tables and two form, Tbl A = Form A, Tbl B = From B. Form B is a
subform to Form A. On the “Load event†of Form B i want field “Bananas†to
become populated with data from fields “Fruitsâ€,â€Basketâ€,â€Colour†in Form A

Me![Bananas] = Forms![A].[Fruits]&â€â€&[Basket] etc.. does not function..

I'm not sure why a field "Bananas" makes sense here. If you only want to
display the information in one field, place a TextBox on your form and
set its Control Source to "=Forms![A].[Fruits] & ' ' & [Basket]".

One way to “almost†solve this would be to build Form B on a query were I
Concatenate the fields..but I want form B to create a new record on load
(Data Entry = Yes) and the way I see it..it cannot create a new record based
on this query...

In most cases like this I prefer two forms: one for displaying the data
and one for data entry.


mfG
--> stefan <--
.