bound text box

[Guest]

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

 

[Damon Heron]

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

Damon

 

[Carl Rapson]

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

 

[Guest]

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,
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