Populating text fields in Reports

[cath_hopes]

Hi there!

I can't seem to get any text fields to populate either via using some VBA within the Report_Load sub nor via the property control source.

Here's some examples of what I 've tried:
Within VBA:

Me.Text2 = Forms("Job Form").[Text23]

and then using the property control source expression builder:
=[Forms]![PropertyForm]![Text24] & " " & [Forms]![PropertyForm]![Property Size]

Can anyone advise?
Thanks in advance!

 

[Rabbie]

Me.Text2 = Forms("Job Form").[Text23]

will only work if form"Job Form" is open.

 

[cath_hopes]

Both "Property form" and "Job Form" are open when the report loads.

 

[cath_hopes]

Its working now. The problem may have been associated with an issue I've raised in a separate thread, namely that I've found my database to become unstable when I've tried opening my report using acPreview. Now I've removed acPreview from the the VBA open report command everything seems to be working ok again!