By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Simple problem of navigation..

P: n/a
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

Oct 5 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Oct 5 '06 #2

P: n/a
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.
Oct 5 '06 #3

P: n/a
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.
Oct 5 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.