Hold Data In A Form 1

[hollyann]

I have a database at work with one of the forms being where the client data entry is done.  Up until about a month ago when you entered a new case the SS# stayed in that field when you entered a new record and stayed in the field until you changed it.  This saved quite a bit of time because we are often entering visits for one client one right after another for several records.  We had done work on the database and ever since then that function stopped working.  Any ideas on how to bring it back?

 

[DougP]

Not sure because your explanatoin is Vague...<br>I guess you added more controls?<br>Look at the TAB Order????<br>Click &quot;View&quot; menu &quot;Tab Order&quot;<br>The top field is where the cursor will be when th eform is opened.<br>Click in the Gray to the left of the field to move it up or down. Click an hold down.<br><br>Other wise you need to be more specific as to what you did.<br>So we can Help.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Cornerstone]

It sounds as if the default value was being changed for the SS field whenever a new one was entered. <br><br>Try this. For the ss# control's After Update event type this:<br><br>field.DefaultValue = [field]<br><br><br>

 

[hollyann]

Thank you Cornerstone....we are up and running great now!