[AccessD] Check Only One

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


-----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:12 AM
To: accessd at databaseadvisors.com; paul.hartland at fsmail.net
Subject: [AccessD] Check Only One

That makes sense, thanks. It has been awhile since I created a database
- forgot about doing it that way.
 
Ok - one question though. The Other field they need to enter text. If
they click Other, would it do to have a txt field activate so they can
type in it? But would that be a separate field from the table that lists
the choices?
 
 
 
Virginia,
If you create a frame and put the checkboxes or radio buttons in a frame
I think this restricts input to only one choice, what you can then do is
assign each choice a value (say 1-4) and store the value in a field.
 
Then you have a table of your choices with two fields, one for the value
and one for the text:
Value          Text
1                 Drill
2                 Injury
3                 Fire
4                 Other
 
then when you do your query, link your main table with the value field,
into your value field, and get it to display the description.
 
Sorry if I haven't made myself clear but am just leaving work....if you
need any further info, contact me here or offline.
 
Paul Hartland

 

-- 
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