Display Info from a Sub form unto the Main Form

[Jamesy_007]

Good Day Everyone.



I have this main form with relevant information also Sub Forms in Tabs linked to the MainForm. However there's this particular field in one of the subforms called lets say AdditionalInfo whose data type is LongText; simple the characters can be more than 255. But this is my theory "I want this info displayed on the main form in a unbound txtbox in sticky-notes type object" reasons its difficult to read in the sub form in datasheet view, also the information can change as new records are added to this particular subform I've tried these Steps..... Step 2 works but not quite

Step 1... cut and paste the subform field into the mainform ....nope!

Step 2... =Control Source to the subform Field.... this only worked when I added the particular table of the same subform to the "Record Source[Query Builder]" meaning it displayed but not when I changed the record to a next row of information remember sub-form is in datasheet view

Step 3... Tried to format a dlook up function it didn't work =DLookup("[AdditionalInfo]", "tblCourtDate", "[Inm_pk] =" & Forms![frmCourtDates]!Inm_pk) i.e. tried to bound this function to the sticky notes type object

Can anyone give suggestions or point out where am wrong ???

[Micron]

Methinks should work if you get the reference syntax right for control source property of this 'notes' textbox on the main form. Maybe

= Forms!FormNameHere!SubformControlNamehere.Form.ControlNameHere

I mention that because I have no idea what "Control Source to the subform Field" looks like in your case. You should always post your attempted code, expressions or references to get more focused responses. Won't work if the subform doesn't load though.

[Welshgasman]

Use the Builder to get the correct syntax?

[Micron]

That actually works for setting the control source on the main form to reference a field on the subform. In my answer, I went by the subforms reference syntax I learned some time ago because I like to do things the hard way! Tested, and I ended up with this syntax:
=[SubformControlName].[Form]![controlName]

Odd that you can't remove the brackets though.

[isladogs]

As an alternative approach, you could have a popup form similar to a zoom box which appears when you click on the long text field in the subform

[Micron]

also Sub Forms in Tabs linked to the MainForm.

I might have misinterpreted that to mean that the goal was to have the info on the main form visible even when some other tab page was showing a different form. If not, I agree that a zoom box is the way to go.

[Jamesy_007]

I might have misinterpreted that to mean that the goal was to have the info on the main form visible even when some other tab page was showing a different form.

Yeah! this was a theory, not sure how practical but the overall goal is to get this info displayed visible clear and not in datasheet view, where the Field AdditionalInfo is; being apart of the sub form

Code:
= Forms!FormNameHere!SubformControlNamehere.Form.Con trolNameHere

This didn't do the trick will try the zoom type form because its not necessary that the info displays when the main form is open but as the records of that particular subform change will like that the information to show visible and clear to the user