code error I don't understand why

[LaughingBull]

Creating a appointment scheduling form and the code error says this must be assigned a "value List" which it already has been.


I have attached the DB for someone to look this over and see what is wrong.
Thank youdates.zip

[Bob Fitz]

Can you tell us exactly what we have to do to replicate your error

[CJ_London]

be helpful if you can guide us to where you get the error - what line of code? which control? at what point - form opening? clicking or tabbing into a control? clicking the dropdown?

only thing I can see at the moment that might be relevant is your code in cboTime_Enter

....
cboTime.RowSourceType = "Value List"
cboTime.RowSourceType = ""
...
...

[LaughingBull]

select a date with the date picker and when you click on the time combo the error appears

[isladogs]

I haven't looked at the code carefully but its giving an error because you haven't set a list of allowed times for the time field
You are specifying its a value list but haven't supplied those values...

[CJ_London]

suggest remove this line

cboTime.RowSourceType = ""

Also recommend you put Option Explicit at the top of each module and select Debug>Compile, you have other errors in your code