Conditions

[John]

Hello,

I need the value of a cell to be updated automatically
depending on the value of another cell. I was told by
someone on the board to enter:

IIf(textbox,value1(IIf textbox, value2,value3))

Where would I enter this information?

Thank you

 

[SteveD]

one way is to have an AfterUpdate procedure for populating
another field.

If or Case statements could be easier and faster.
note: always put the most likely answer 1st.

such as:
If me.textbox = something then
me.anotherfield = somevalue
Else
me.anotherfield = differentvalue
End if

This could be a <> condition and if additional conditions,
use 'ElseIf', where the last condition is 'Else'.

SteveD

 

[Tim Ferguson]

I need the value of a cell to be updated automatically
depending on the value of another cell.

No you don't, you need a data structure redesign. No field should depend
for its value on any other field except for the PK.

It might help to do some reading on second normal form, and R theory in
general.

B Wishes


Tim F