Best approach for signup database

[MaxTO]

Hello,

I am creating a database that users will be using to pick dates from. The last time, I created a Yes/No field for each of the dates that were available and the users would use a checkbox on a form to make their selection.

I am wondering if there is a better way of getting this done, such as having only a "Date" field (each user can have more than one record in this case). However, I'm not sure how I'd go about making this a checkbox on a userform.

Any input or direction would be appreciated.

Thanks,

 

[pbaldy]

Yes/No fields for each date would be a design mistake (normalization). You're on the right track with available dates being records. I'd use a combo or listbox to let the user select them. Presuming they can choose more than one, I'd go with the listbox and a technique like this to add records to the table:

http://www.baldyweb.com/MultiselectAppend.htm

More info about the app will let us be more specific with design ideas.

 

[MaxTO]

Thanks for the quick reply.

To give you a better understanding of what I'm trying to accomplish...

I'll have a userform popup when a user enters the database. On the form, they will fill out their name, dept and similar info. Below that, going across, I will have different months (Ie. Jan all the way to December), and below each of the months will be 4-5 weeks (depending on the month). The user is expected to pick 2 weeks from under each of the months. In the past I used the checkboxes because I find it that users like the simplicity of it, however, if I have to use a listbox, then I will look into going that route.