Update linked table

[Peter Neumaier]

Hi NG!

I am trying to update a linked table through an access form.

My form receives its data through a query (defined as "Record Source")
and contains a textfield. The current status is, that after updating
the textfield, my table gets only updated if I leave the form. I would
like to update the linked table after leaving the textfield.

What is the way to make that happen?

Thank you and regards,
Peter

 

[Pieter Wijnen]

put your code in the fields afterupdate event instead of the forms
afterupdate

Pieter

 

[Pieter Wijnen]

put your code in the fields afterupdate event instead of the forms
afterupdate

Pieter

 

[Peter Neumaier]

there is no code, that is what I am asking for?

thx&regards

 

[Peter Neumaier]

there is no code, that is what I am asking for?

thx&regards

 

[Pieter Wijnen]

If you use a macro, same thing applies (afterupdate or close)

HTH

Pieter

 

[Pieter Wijnen]

If you use a macro, same thing applies (afterupdate or close)

HTH

Pieter

 

[Peter Neumaier]

how to update the table with the inserted data in the textfield, that's
all I need!?

regards
peter

 

[Peter Neumaier]

how to update the table with the inserted data in the textfield, that's
all I need!?

regards
peter

 

[Pieter Wijnen]

In the AfterUpdate Event of the Control (Click builder icon .. /select Event
Procedure)

Private Sub Text1_AfterUpdate
On Error Resume Next
Me.Dirty = False
End Sub

 

[Pieter Wijnen]

In the AfterUpdate Event of the Control (Click builder icon .. /select Event
Procedure)

Private Sub Text1_AfterUpdate
On Error Resume Next
Me.Dirty = False
End Sub

 

[Peter Neumaier]

i got a date of format mm/dd/yy in the textfield your code screws up
the whole format ...

 

[Peter Neumaier]

i got a date of format mm/dd/yy in the textfield your code screws up
the whole format ...

 

[Pieter Wijnen]

no, but access does if your regional settings differ from mm/dd/yy (Access
then displays the data according to these settings)

Pieter

 

[Pieter Wijnen]

no, but access does if your regional settings differ from mm/dd/yy (Access
then displays the data according to these settings)

Pieter

 

[Peter Neumaier]

sry, to avoid confusion, i probably didnt say it properly ....

access changes my date format to a time format?

 

[Peter Neumaier]

sry, to avoid confusion, i probably didnt say it properly ....

access changes my date format to a time format?

 

[Pieter Wijnen]

change the format property to mm/dd/yy (should do the trick)

Pieter

 

[Pieter Wijnen]

change the format property to mm/dd/yy (should do the trick)

Pieter

 

[Peter Neumaier]

doesnt work, after editing the textfield, the value jumps automatically
to 12:00 am