setting default value

[icemonster]

hi, i have a table question.

thing is, i have fields in my table, a yes/no field, how do set it to have default value if, lets say, field A, is 1 then field B C D E are all yes, but if field A is 2, only B C D are yes and E is no.

thanks for any help!

 

[gemma-the-husky]

not sure you can do it with default values

instead when you add a new record in a form, or whatever, you can set the values you want for BCDE, based on the value you enter for A (maybe after update event for field A)

 

[pkstormy]

You could use an IF in code to set the default value (possibly in an afterUpdate or some other event.)
ex:
if [SomeField]="SomeValue" then
me.SomeOtherField.DefaultValue = "=" & me!XXField * me!YYField
else
me.SomeOtherField.DefaultValue = "=" & me!VVField + me!AAField
end if

or something like
if me!FieldA = True and me!FieldB = "B" and me!FieldC = "C" then
me.SomeOtherField.DefaultValue = "=" & me!XXField * me!YYField
else
me.SomeOtherField.DefaultValue = "=" & me!VVField + me!AAField
end if

or something like
if me!FieldA = True and (me!FieldB * me!FieldC = "D") or (me!FieldM * me!FieldN = "D") then
me.SomeOtherField.DefaultValue = "=" & me!XXField * me!YYField
else
me.SomeOtherField.DefaultValue = "=" & me!VVField + me!AAField
end if

or something like
if (me!FieldA = True and me!FieldB ="B" and me!FieldC=1) or (me!FieldA = False and me!FieldD = 1) or (me!FieldM * me!FieldN = "D") then
me.SomeOtherField.DefaultValue = "=" & me!XXField * me!YYField
else
me.SomeOtherField.DefaultValue = "=" & me!VVField + me!AAField
end if

or even use a select type case statement to set the default value.

etc...etc...

You can expand on this to meet your specific situation. The key is putting the code in the correct AfterUpdate on specific fields or other events.