[AccessD] Check Only One

In the AfterUpdate event of the combobox, write this:

	If cbo = "Other" then
		memOther.Enabled = True
	Else
		memOther.Enabled = False
	endif

The control source for the Other field will be in the Main table, not in the
lookup table.  Then when you create a report (bound/filtered from the Main
table) for your information you'll have a field which shows your selection
as text, and another which shows the content of the Other field.  If they
didn't select Other, then the report field for Other will be blank.  This
shouldn't bother your users, because they can see the selection that was
chosen from the list, or they can see that Other was selected and then they
can read what Other actually meant.

If your report just said Other, but there was no Other field, then users are
left by themselves to wonder what Other actually was.

But, in your particular process, it MIGHT be that the users are actually
fine with an Other selection without an explanation.  


Dan Waters


-----Original Message-----
Subject: [AccessD] Check Only One

That makes sense. I created a new lookup table listing the 4 choices &
Other as number 5. I store the number they selected in the main table. I
got that part. Put the option frame/box on the form.
 
What do I do now about the Other choice. I can make the field show or
enable it if the choice is 5 (Other). But how do I show their write in
text for the Other field in a report?
 
Would it be a field in the other main table? The reports would have to
determine if Other is the choice & if it is put in the text they typed
in the Other field from the main table. Does that sound right?
 
Virginia
 
 
 
Virginia,
 
In the after update event of the option frame you could check to see if
they've selected Other and then enable or disable your text box. Or make
it
visible or invisible.
 
Rocky
 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com