Terpsichore
Registered User.
- Local time
- Today, 02:10
- Joined
- Jun 5, 2006
- Messages
- 34
Hi,
I have some code that generates an email from fields on a form but I want to add some specific text from a table as well.
I have a table "EmailText" with two fields ID, TextDesc. I want to create some code that grabs the TextDesc text for a specified id and either places it in a field in the form (so I can then use that field in my code) or be able to add the query result directly to my email code.
So, for example if EmailText.ID = 3 I want a field to show the TextDesc field for that ID - in a form field for simplicity. So in the form, the result would show up in field me.textforemail.
I'm sure this is fairly simple but I just can't remember how to do it - a the joys of only updating my code every few months.
Help appreciated. tia
Terpsi
I have some code that generates an email from fields on a form but I want to add some specific text from a table as well.
I have a table "EmailText" with two fields ID, TextDesc. I want to create some code that grabs the TextDesc text for a specified id and either places it in a field in the form (so I can then use that field in my code) or be able to add the query result directly to my email code.
So, for example if EmailText.ID = 3 I want a field to show the TextDesc field for that ID - in a form field for simplicity. So in the form, the result would show up in field me.textforemail.
I'm sure this is fairly simple but I just can't remember how to do it - a the joys of only updating my code every few months.
Help appreciated. tia
Terpsi
Thank you! Got it working now!
