Feidl updates 1

[coopermarsh]

Hi how do i, in ms access 2010 set one field to false when another field is set to true?

 

[Andrzejek]

If OneField and AnotherField are declared as Boolean:

OneField = Not(AnotherField)

Have fun.

---- Andy

 

[coopermarsh]

excuse my ignorance where would I do this.

I only want it do update the other field to false when i up the current feild.

 

[MajP]

Prior to 2010 you could do that only on a form normally in the afterupdate of the first control. However, if the values were changed in a table or query there was no way to trap that change. 2010 now has data macros at the tables level. Now with data macros you basically can trap a change in data at the table level. See here:

http://msdn.microsoft.com/en-us/library/ff973807.aspx

one question
if the first control changes to true you want the second to become false.
if the first control changes back to false then do you want to do nothing?

If so in the afterupdate of somefield
if me.somefield = true then me.someotherField = false
or if true becomes false and false becomes true like Andy shows