Change value in seperate table based on form..

[wh00t]

Hi
I would like to achieve the following

I have a form based on a table, when I enter a value in a certain field, I would like a field in another (seperate) table changed with the entered value.

Also which 'event' would best trigger this? OnExit, OnLostFocus, BeforeUpdate?

Thanx in advance

GC

 

[sofie]

I tried your repley, but my computer says it is wrong.
Private Sub cmdSearchClient_Click()
DoCmd.OpenForm "frmKlantenfiche", acNormal
Forms!Products.Filter = "naam_kl = [Which Client are you searching for?]"
Forms!frmKlantenfiche.FilterOn = True
Forms!frmKlantenfiche!Naam_kl.SetFocus
End Sub


In the third line is the fault.

What do I have to do?

Tnx a lot.

Sofie

 

[wh00t]

sorry my error, I forgot to change the form name to your form name, try this

Private Sub cmdSearchClient_Click()
DoCmd.OpenForm "frmKlantenfiche", acNormal
Forms!frmKlantenfiche.Filter = "naam_kl = [Which Client are you searching for?]"
Forms!frmKlantenfiche.FilterOn = True
Forms!frmKlantenfiche!Naam_kl.SetFocus
End Sub


[This message has been edited by wh00t (edited 01-17-2002).]