setting textbox default value at run time

[Saxie1]

I am using an option control to set the value of a text box in a form. When I add the record to the database the value transfers to the data base but the text box goes blank for the next record. How do I get the textbox value to stay the same in the next record unless the user changes it? This should be easy, but I just can't seem to get it!!!!<br>
thanks for the help, I'm pulling my hair out

 

[WP]

I assume it is a bound form ?<br>
<br>
If so then set the default value on the table field.<br>
<br>
Hope this helps.<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[DougP]

It is a no brainer if your form's &quot;Record Source&quot; has something in it.<br>
AS Bill mentioned go in design view and pull up the forms properties.<br>
1. Is there something in the &quot;Record Source&quot; property.<br>
it's the top property, click the all TAB<br>
2. If so the your form is attached.<br>
<br>
Is there something in the textbox in question or does it say &quot;Unbound&quot; <br>
3. double click on it<br>
4. Look at the Second property from top &quot;Control Source&quot; <br>
5. If you click in the far right side of it there is an arrow. Click it you will see all of your Fields<br>
<br>
Or are you Calculating a value for this Textbox?<br>
In which case the Control Source has a calculation in it.<br>
This requires a different approach.<br>
<br>

 

[Lehtoant]

Saxie,<br>
<br>
I figured out that you are trying to refer to previous record and set default value dynamically according to user's selection.<br>
<br>
There's an article in MS Knowledgebase:<br>
<A HREF="

http://support.microsoft.com/support/kb/articles/Q101/0/81.asp?LNG=ENG&SA=ALLKB"

TARGET="_new">

http://support.microsoft.com/support/kb/articles/Q101/0/81.asp?LNG=ENG&SA=ALLKB</A><br>

<br>
With Dlookup-function in form's Default Value property you can refer to previous record and get the values to a new record (assuming you have sequential ID field)<br>
<br>
Good luck,<br>
Al

 

[Saxie1]

Lehtoant,<br>
This Dlookup article looks like exactly what I need. I haven't actually tried it yet, but it looks very promising. Thank you so much for taking the time to answer my cry for help.<br>
Saxie