Update table

[MAK9974]

hi Guys.
Help me.
I have a table A with 3 columns. and another table B with one column. If anybody updates a record in table A, i want the third column value to be updated in table B.

Table B always has only one record and only one record will be updated in table A all the time.

I need something like update trigger which will fire an update statement.

Please advice.

-MAK

 

[jgoodman00]

If this is done at form level, you can use the Before_Update event, & a normal UPDATE SQL statement. Run it using the DoCmd.RunSQL method... James Goodman