Update linked table

#1 (**permalink**) 28-Jul-2006, 08:09 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10080-update-linked-table.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080

What is the way to make that happen?

Thank you and regards,
Peter

*

#2 (**permalink**) 28-Jul-2006, 08:09 AM

put your code in the fields afterupdate event instead of the forms
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
afterupdate

Pieter

"Peter Neumaier" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
news:1148297378.687438.128610@38g2000cwa.googlegro ups.com...
> 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
>

#3 (**permalink**) 28-Jul-2006, 08:09 AM

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

thx&regards

Pieter Wijnen wrote:
> put your code in the fields afterupdate event instead of the forms
> afterupdate
>
> Pieter
>
> "Peter Neumaier" wrote in message
> news:1148297378.687438.128610@38g2000cwa.googlegro ups.com...
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
> > like to update the linked table after leaving the textfield.
> >
> > What is the way to make that happen?
> >
> > Thank you and regards,
> > Peter
> >

#4 (**permalink**) 28-Jul-2006, 08:09 AM

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

HTH

Pieter

"Peter Neumaier" wrote in message
news:1148301936.714768.142620@y43g2000cwc.googlegr oups.com...
> there is no code, that is what I am asking for?
>
> thx&regards
>
> Pieter Wijnen wrote:
>> put your code in the fields afterupdate event instead of the forms
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
>> afterupdate
>>
>> Pieter
>>
>> "Peter Neumaier" wrote in message
>> news:1148297378.687438.128610@38g2000cwa.googlegro ups.com...
>> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
>> > 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
>> >
>

#5 (**permalink**) 28-Jul-2006, 08:09 AM

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

regards
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
peter

#6 (**permalink**) 28-Jul-2006, 08:09 AM

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" wrote in message
news:1148303037.420380.91990@u72g2000cwu.googlegro ups.com...
> how to update the table with the inserted data in the textfield, that's
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
> all I need!?
>
> regards
> peter
>

#7 (**permalink**) 28-Jul-2006, 08:09 AM

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

#8 (**permalink**) 28-Jul-2006, 08:09 AM

no, but access does if your regional settings differ from mm/dd/yy (Access
then displays the data according to these settings)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080

Pieter

"Peter Neumaier" wrote in message
news:1148304583.202725.299700@i39g2000cwa.googlegr oups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080
>i got a date of format mm/dd/yy in the textfield your code screws up
> the whole format ...
>

#9 (**permalink**) 28-Jul-2006, 08:09 AM

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

access changes my date format to a time format?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10080