Combo box for two fields

[joe]

Hello,

I have a form that needs two fields added onto it.For one field, i was thinking a drop down list using the lookup wizard with the following values--- the days of the week Mon,Tues,Weds,Thurs,Friday.Another field with a drop down list using the lookup wizard for each day of the month, 1,2,3,4,5,6,7, etc,etc.These two fields would be created in the timecard table but i would like to know if there is an easier method such as a combo box on the form that would achieve the same results as appearing in a report???Can a combo box be applied in this way? Thanks

 

[John Vinson]

Hello,

I have a form that needs two fields added onto it.For one field, i was thinking a drop down list using the lookup wizard with the following values--- the days of the week Mon,Tues,Weds,Thurs,Friday.Another field with a drop down list using the lookup wizard for each day of the month, 1,2,3,4,5,6,7, etc,etc.These two fields would be created in the timecard table but i would like to know if there is an easier method such as a combo box on the form that would achieve the same results as appearing in a report???Can a combo box be applied in this way? Thanks

I actually would a) never use the Lookup Wizard under any
circumstances (see http://www.mvps.org/access/lookupfields.htm for a
critique); and b) not store this data in the table at all. You can
store a date/time field in the table and *show* Mon or 1 or the day of
the month; you can use a Calendar control to allow the user to just
pick a day off a calendar.

I guess I'm not sure what these fields are intended to accomplish!