Regarding this:
So are you saying that you have 3 columns being displayed in the combo box: 4,4, timevalue?When I use the drop down box, regardless of what day I select, it displays 4 and 4 as the two choices...
If so, you just need to adjust the column widths to zero for the columns you don't want the user to see.
Regarding this:
I assume these combo boxes are bound to your faculty table, if so having a default value of zero could cause relationship issues since you probably do not have a faculty member that has a zero primary key value. I also assume that you are still talking about combo boxes on a form and not at the table level.I tried making the default value for all the combo boxes No, but they appear as zeros, and I encountered problems while building the code to facilitate my needs. Have you had experience with this type of thing? It is probably dead simple, but the dynamics of a combo box are throwing me off...
If a person can make multiple faculty appointments then that should be in a separate but related table and those appointments should be represented in a subform with each appointment being a separate record.
Can you explain your table structure in more detail relative to these appointments?