[AccessD] Check Only One

If you've saved the data in the text box which is enabled if they select
Other in a field in a table, as I assume you have, then you include that
field in the query which is the source for your report.  

Then in the Detail Format event of the report, check the value of the field
that holds 1-5.  If it's 5 make the text box on your report which is bound
to the Other field Visible.  Else Visible = False.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Monday, October 23, 2006 9:58 AM
To: accessd at databaseadvisors.com
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

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.9/490 - Release Date: 10/20/2006