Dynamic Form

[guitardave78]

Is it possible to dynamically create a form with a text box on it?
Basically I have a string created from a record set that i want to popup in a text box in a new form.

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[jebry]

Hi!

Is there some reason that this can't be done with a message box?

MsgBox YourString

will pop up the message box with your string displayed.

You could also create a form with a text box and just call it and pass the string to it.

DoCmd.OpenForm "YourForm", , , , , , YourString

Then in the open event of your form:

Me!YourTextBox.Value = Me.OpenArgs

hth

Jeff Bridgham
Purdue University
Graduate School
Data Analyst