Simple problem of navigation..

[rakeshv01]

I have got a main form in which there is a subform. In the subform I
have a textbox, which is not bound to any fields of a table. This
textbox gets updated by certain value if the condition satisfy..

I want to know how to clear this textbox when I have moved on to the
next record in my main form. Basically, I know how to clear a textbox
all I want to know is how to determine if I have moved on to the next
record in my main form.

cheers
Rex

[Tom van Stiphout]

On 4 Oct 2006 18:06:38 -0700, ra*******@gmail.com wrote:

Unbound controls in subforms (I'm assuming in datasheet view) often
are a bad idea, as you may soon find out.

When you move to a next record, the Current event occurs.

-Tom.

>I have got a main form in which there is a subform. In the subform I
have a textbox, which is not bound to any fields of a table. This
textbox gets updated by certain value if the condition satisfy..

I want to know how to clear this textbox when I have moved on to the
next record in my main form. Basically, I know how to clear a textbox
all I want to know is how to determine if I have moved on to the next
record in my main form.

cheers
Rex

[Rex]

Thanks Tom, that worked.. the unbound control I have is on a single
form view..

I also wanted to know. How to copy a value from a textbox in the
previous record into the current record.

cheers
Tom van Stiphout wrote:

On 4 Oct 2006 18:06:38 -0700, ra*******@gmail.com wrote:

Unbound controls in subforms (I'm assuming in datasheet view) often
are a bad idea, as you may soon find out.

When you move to a next record, the Current event occurs.

-Tom.

[Tom van Stiphout]

On 4 Oct 2006 19:54:35 -0700, "Rex" <ra*******@gmail.comwrote:

Check this out:
http://www.mvps.org/access/forms/frm0012.htm
and bookmrk that site!

-Tom.

>Thanks Tom, that worked.. the unbound control I have is on a single
form view..

I also wanted to know. How to copy a value from a textbox in the
previous record into the current record.

cheers
Tom van Stiphout wrote:

>On 4 Oct 2006 18:06:38 -0700, ra*******@gmail.com wrote:

Unbound controls in subforms (I'm assuming in datasheet view) often
are a bad idea, as you may soon find out.

When you move to a next record, the Current event occurs.

-Tom.