Default value in text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wideawake - 08 Jul 2005 21:38 GMT

I have a datasheet form that has a text box named txtBalance. I would like
the txtBalance default value in a new record to be the value entered in
txtBalance of the prior record. Thanks in advance for your help!

Reply to this Message

Marshall Barton - 08 Jul 2005 22:28 GMT

>I have a datasheet form that has a text box named txtBalance. I would like
>the txtBalance default value in a new record to be the value entered in
>txtBalance of the prior record. Thanks in advance for your help!

Use the control's AfterUpdate event:

Me.txtBalance.DefaultValue = _
"""" & Me.txtBalance.Value & """"

Signature

Marsh
MVP [MS Access]

Reply to this Message

David C. Holley - 09 Jul 2005 05:14 GMT

In the afterUpdate() event txtBalance.DefaultValue = Me!txtBalance

> I have a datasheet form that has a text box named txtBalance. I would like
> the txtBalance default value in a new record to be the value entered in
> txtBalance of the prior record. Thanks in advance for your help!

Reply to this Message