almost got it....

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Way to go H,

You solved another problem of mine. I hate to push my
luck, but here goes a last and final question...

Building on my previous question/problem... I now have the
text box (labeled "Other") being visible and not being
visible depending on whether or not the 7th check box is
checked. Is there a way to make the "other" text box
delete its contents if another check box is selected
besides the 7th check box? Does this make sense?

Here is a senerio: When you open the form to edit... you
are asked (a query) to enter a name... then that unique
identifier (name) fills in the form from information from
a table... there are 7 check boxes to select from... one
being "other"... and if "other" is selected a text box is
made visible and the user can fill in a more descriptive
entry... so, back to the senerio... if you open up the
form and the 7th check box is marked there will be a text
box with data... and if you select another check box
the "other" text box is made not visible... good so far...
now, is there a way to delete/empty the "other" text box
contents if another check box is marked?

Thanks for your help!!!!!
 
Mark,
I'll bet this is not your last question - maybe the last question for the
day :)

To Answer your question:
that another check box: Let us say it is chkbox8
in it's after update event

if me.checkbox8 = -1 ' if it is checked, avoids the null situation
me.txtOther.Value = ""
end if

Try using = True
it would make your code more understandable too.

HS
 
Back
Top