[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