default text on a form unless.....

[Marshallp24]

Hi,

I have a form that I need to add text to certain fields based on
answers in other fields, which I've done basicly like this:

on_load
if me.answer1 = "yes"
then
me.feedback1 = feedback yes"
end if
end sub

thats ok it works but I want it so that if the feedback field is
edited in any way I want it to stay that way. Right now if I add text
it disapears when I load the form back up.
Need some sort of unless its already done statement.

Can anyone help???

Cheers

[Rick Brandt]

Ma*********@gmail.com wrote:

Hi,

I have a form that I need to add text to certain fields based on
answers in other fields, which I've done basicly like this:

on_load
if me.answer1 = "yes"
then
me.feedback1 = feedback yes"
end if
end sub

thats ok it works but I want it so that if the feedback field is
edited in any way I want it to stay that way. Right now if I add text
it disapears when I load the form back up.
Need some sort of unless its already done statement.

on_load
if me.answer1 = "yes" _
and IsNull(me.feedback) then
me.feedback1 = feedback yes"
end if
end sub

Technically this seems like redundant data. Why have "feedback yes" in one
field if "yes" in another field conveys the same information?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com