bound text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

big t - 20 Mar 2007 15:49 GMT

sorry if this is a really dumb question but i'm new to this access thing.

i have a text box on a form which is bound to a date field in a table. when
i open the form, the text box displays the value in the field - that's great.

but what i can't figure out is when a new value in the text box updates the
value in the table? i type in a new value, but if i check the value in the
table it hasn't updated. it seems like it only updates when i close the form.
is this normal?

i thought a bound text box would immediately update the value in the table
it is bound to.

TIA
big t

Reply to this Message

Damon Heron - 20 Mar 2007 16:18 GMT

Your form represents a complete record. It only updates if you proceed to
the next record or close the form.

Damon

> sorry if this is a really dumb question but i'm new to this access thing.
>
[quoted text clipped - 15 lines]
> TIA
> big t

Reply to this Message

Carl Rapson - 20 Mar 2007 16:19 GMT

Yes, that's normal. Access only updates the table when you move off of the
current record (either to another record or close the form). You can,
however, "force" Access to update the table by putting the VBA code

Me.Dirty = False

in the AfterUpdate event of the text box.

Carl Rapson

> sorry if this is a really dumb question but i'm new to this access thing.
>
[quoted text clipped - 15 lines]
> TIA
> big t

Reply to this Message

big t - 20 Mar 2007 16:30 GMT

that's great. thanks fellas.

cheers,
big t

> Yes, that's normal. Access only updates the table when you move off of the
> current record (either to another record or close the form). You can,
[quoted text clipped - 25 lines]
> > TIA
> > big t

Reply to this Message