"Other, please specify" in List

[captpete]

I am creating an Access data entry form based on a government questionaire. I want to create a drop-down list that includes an entry entitled "Other, please specify", similar to the questionaire in question. I would like to do a sort on the "Other" field so that I can see what these "Other" entries are. If the person clicks on "Other", how do I get the user to the point where they can enter the new specification? Would I need an additional field to store the input? Or a seperate table? I don't see how OnNotInList would work because they are choosing a selection, "Other", that is in the list, but the answer will not be "Other". What I would like to happen is when they choose "Other", the answer would be "Other" for sort purposes, but with specific answer for that record.

 

[Paul_Bricker]

In the AfterUpdate event for your combo box, you could test to see if "Other" was selected. If it was, you could open another form that would handle the information related to Other and store it in a seperate table. In the mean time, the original selection would be stored in the table underlying your first form so that you could query for it or sort by it when ever you needed.
You wouldn't need any code except to open your second form.

HTH
Paul

 

[captpete]

I'll try that, thanks.