By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

default text on a form unless.....

P: n/a
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

Mar 11 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Mar 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.