use input box data as default value

[Guest]

Well here I am again with another queston ( but I guess thats the way to
learn) anyway.

I know how to get an input box to open when a form loads but how can I get
the data that was entered into the input box to be the default data in one of
the fields
on my form?

Thanks in advance for any help

 

[Guest]

Try this in your form load event

me.MyControl.value = InputBox("There it is")

Obviously, replace "MyControl" with the name of your control.

Yanick

 

[John Welch]

Me.SomeControl.DefaultValue = "'" & InputBox("enter default value") & "'"