Updating

[cmaceHWI]

I have two tables in my database, each table has a field named "Export". Each field is a checkbox. Is it possible that when I check the field in the first table it will update the field in the second table? I was thinking along the lines of placing code in the After Update event that went something like this

if [1st table]!export.value = True
then [2nd table].export.value = true
else
[2nd table].export.value = false
end if

this did not work. Does anyone know the correct way to code this or another way to achieve this?

 

[PHV]

Seems you want a Trigger and ms-access lacks this.
The workaround is to force the users to update the tables through forms with event procedures.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya cmaceHWI . . .

[blue]Is it possible that when I check the field in the first table it will update the field in the second table?[/blue]

Yes its possible, but how do you intend to synchronize the the record in table1 thats checked with the record in table2 thats to be checked?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .