Function within text

[remcopeters]

I want to display a line of text in which I want a function to lookup a value within a form. Is this possible?
So for example:

"Welcome" [lookup username on login form] "Enjoy your stay."

 

[apr pillai]

Create a Textbox on your Form where you want to display the message and write the following expression in the Control Source Property of the Textbox:

="Welcome " & Forms![login form]![UserName] & " Enjoy your stay."

NB: The login Form must remain open for the above lookup to work.

If you are looking for a method similar to Mail-Merge then take a look at the following blog posts:

• Ms-Access and Mail-merge-2
• Ms-Access and Mail-merge-3

 

[remcopeters]

Thank you.

What I want to use it for is the following:

I got a form where a user can enter data. This data is stored in tables. Next, I want the user to be able to generate a report based on these tables. I also now saw your links about mailmerging but can't figure them out .....

Can you tell me how I can do this?