Populate a form with text using macros

[Ligaya]

Hello,

I have not used my small knowledge of ACCESS for a while. Could someone please help me with this.

I have a form that needs at least 4 four-sentence paragraph to be inserted to a form when a button is clicked.
For example: button 1 when clicked would populate a text box with the paragraph- " We regret that we cannot action your request at this time. Please contact our helpdesk during business hours on 02 9222 333 444. etc".

Command button 2 would enter on the form, " Thank you for your enquiry. We are happy to provide the details of your recent order, etc, etc, etc.

This form with the statements will be printed as a report.

Could someone please give me a hint at where to start?

Many thanks!

Regards,
Ligaya

 

[burrcm]

Button one - On click event - Event procedure - [Textbox1] = "We regret that we ....."
Button two - etc.

Chris B

 

[Ligaya]

Hello Chris,

Thank you for your prompt reply. Unfortunately, I tried it and got nowhere. I will try it again and who knows, something might click in my brain and I will get it going.

Thank you again.

Regards,
Ligaya

 

[burrcm]

Is this what you had in mind? (Sample attached).

Chris B

 

[Ligaya]

Yes, it is!, thank you very much, Chris!

When the report is printed, only the comments will show in the report, is that correct?

But I tried and copied what you sent to no avail. I am feeling frustrated that I cannot make it work.

My brain cells have certainly atrophied.

Regards,
Ligaya

 

[burrcm]

OK. Moving right along - to produce a report, you must base it on a query or table. Have a look at this expanded version. I have based the report on the table but you should put a query in between. This will do for the demo though...

Chris B

 

[Ligaya]

populate a form with text...

Hello Chris,

I really appreciate your input and I shall try it out when I go back to work.
Thank you so much for your help.

Regards,
Ligaya