Font color change from drop-down selection

How can I change the font color when a user selects a specific color from a drop down menu on a form and have it write to a table within the form? Attached is the file. Any help is greatly appreciated.

Good news!

I got this working for ya! See the attachment code.

All I did was add in a Select Case and based on the color choosen from your drop down menu, set the color code accordingly, such as: "#ff0000"

You can use the same technique for font face as well, such as: Arial, Times, etc.

Hope it relieves some grief for ya.

Note: You'll need to uncomment the parts that I commented out in order to test this out. The parts were: the email portion, the database connection string, and the execute sql.

Thanks. I got it to work as well. Appreciate the help.