pre-fill forms

[dah]

Hi,

I need to know how to create a macro that will take what has been
entered into a form text box and put the same informtion into other
text boxes on the form.

For example: a person's name has been entered into the Name box and at
the end of the form is another box. I would like the 2nd box to
automatically fill with any information that was entered into the 1st
text box. Is this possible?

Thanks

 

[Malcolm Smith]

Easily. There are a couple of events which you could use.

One is the KeyPress event of the source text box which could be used to
copy the textbox .Text property to the target's .Text property.

Or you could use the OK button's .Click event to do this when the form is
complete.

Have a play with the events of the Textboxes. If you're stuck then give
me a shout and I'll knock up an example for you.

Regards
- Malc
www.dragondrop.com

 

[Greg Maxey]

Dah,

Malcolm is talking about a UserForm and believe me he knows his business.
If you are talking about a on line form contructed using the Forms toolbar
you might fing the following helpful:

http://gregmaxey.mvps.org/Repeating_Data.htm

 

[dah]

Thanks. Those suggestions worked nicely.

Now the form (which is normally printed as a hard copy in addition t
being online) has many textboxes and checkboxes that work nicely.
user fills in the form with the appropriate information (the form i
used to take orders for different machine parts). I now need a packin
slip (say the last page) to be automatically printed with an
information that was selected previously in the form. Doesn't see
that using a [Ref] code works since there are too many choices fo
different parts.

How could I write a macro that would pull and print only th
information checked in the form? I'm guessing that some form of an I
statement may work. I would need the macro to look back over the for
and if a check or text box has information in it, print tha
information on the packing slip page.

Any thoughts?

Thanks