Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Forms /

Status
Not open for further replies.

sabascal

IS-IT--Management
Aug 20, 2002
85
GB
Hi all,
Quick question related to use of forms.
I converted old dialogueSheet into a form.
- In the dialogueSheet: when user was input a string in an EditBox next time he was reopening the dialog the value has been recorded.
- In my new form: if I type a text in a EditBox, next time I open the form, the string has disappeared.

How could I by pass that?
Thanks

 
The dialog sheet stored its data right on the sheet so it automatically remembered. In today's forms you need to set the Control Source property to something like "sheet1!a1" (without the quotes) to have the contents stored somewhere other than the transitory form object.

Ron
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top