Hiya Folks!

I have a form and subform. The form only has a "date" field in this format dd-mm-yyyy. The subform has sales details for the date in the main form.

I created a combo box in the main form that searches for the record based on the value I select. In this case, the value is a "date" value in this format: dd-mm-yyyy.

Another thing I have done is that when the user clicks on the combo box so he can search for the record with that date, the Calendar control appears so that the user can select the date that he wants from there.

The problem I am experiencing is that when the user selects the date that he wants, and the value from the Calendar object is transfered to the combo, I recieve an error message saying that the value type is not correct. I cant seem to figure out what is going on... the value type is set for the combo is "Short Date". And the field that contains the value in the table is also set as "Short Date".

Can anyone help? Thanks!!!

See post in the Access section. You are using too many controls and not using the combo box correctly. Also, this should probably be a Report, not a form/subform.



mmcdonal