DtPicker Control Source

[SirDrinksalot]

Hi All,

I'm having a wee problem with a form containing a DTPicker Control. It should display the date for a given record, as defined by the control source, however instead it seems to always displays the default date instead. Does anyone know why this might be happening? I have tried removing the default date but that's not an option, and when the user loops through the records in the control source it populates all of the other controls except the dtpicker control!

TIA

Dan

 

[gemma-the-husky]

what is the name of the control source field storing the date. Its not just "date", is it. That might give you a problem as date() returns the current date.

 

[SirDrinksalot]

Hi Gemma,

Thanks for the response. The DTPicker control is bound to a field called d_date in the table in question, but upon further investigation it seems to be an anomaly of the control. I found that once I move to the next record the date updates to that of the record, and even when i now go back to the first record the date is correct.

Regards

Dan