Concatenation

  • Thread starter Thread starter Peter
  • Start date Start date
P

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!
 
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..
Click to expand...
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...
Click to expand...
In most cases like this I prefer two forms: one for displaying the data
and one for data entry.


mfG
--> stefan <--
 
You are correct Stefan..i will choose that path, Thanks!

Stefan Hoffmann said:
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..
Click to expand...
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...
Click to expand...
In most cases like this I prefer two forms: one for displaying the data
and one for data entry.


mfG
--> stefan <--
.
Click to expand...
 
Back
Top