Replies

Might work. I’ll play with it and let you know. I need to be able to count them at the end of the month. For instance, how many dam permits were there for January? I think with your yes/no, I can still create a query to count.

Thanks for the idea. I’ll try it.

Ok. That makes sense. I guess my thinking is all awry then. Maybe you can suggest a solution to my dilemma. I have a database that is used to track permits issued for land use. I have a group of items for the authorized use (boat launch, recreation, conservation, dam, etc.). Sometimes, I need to select more than one of these items for one permit issued.

How can I do that? I originally set up an option group with radio buttons, but soon discoverd that I can only select one item. Then I read about the mulit-select list box and thought was the answer.

I apologize for my ignorance here and appreciate any suggestions you might have.

I am now thinking I might have to set up a separate table for the results and have them linked to the main table and on the form just have a sub form to enter each item separately. Make sense? I’m still thinking this through.

Thanks!!

Thanks, Charlotte. I knew that, but it still isn’t keeping the selections I make. I have used the shift-click to select 3 items, and when I move to the next field, my selections either disappear, or they are the same for all records in the database. Does that explain my question better?

Thank you all so much for your input. I appreciate the time you too. Yes, I was on the other board, and hope to learn W2K well enough that I can contribute something to this board one day.

Thanks!!!
Melanie