Display Message

[jerky1001]

Hello all:

Ok what I’m trying to do is have a message displayed (the message is going to be generated based on the results of a query) but not in a message box, instead I want it on the form (I’m guessing I’m gonna have to use a text box of some sort). Also I don’t want to have to use a table or temp table to hold the message I just want it to be sent to the text box. Is this possible and if so how?

Thanks in advance.

 

[bubba100]

Why don't you the text box already there with the message and depending on the results of the query make the the text box visible or not.

 

[jerky1001]

If I can I’d prefer to do it a little cleaner than that, also I may have to add many messages, and I don’t really want to clutter up the form.