H
Henry Smith
I have inserted a datepicker control on a form that includes text boxes with
name, address, etc.
What I want to see is the datepicker control to display the acquisition date
of the lot owner of a community.
This date is a field in the lot owners table.
In the form open code I have a query that opens a record set that includes
the acquisition of the lot date field.
Set Rs = db.OpenRecordset(strSQL, dbOpenDynaset)
With Me
.txtEditPriTeleSec.Value = Rs.Fields("tblOwner_Telephone_Sec")
.txtEditPriEmail.Value = Rs.Fields("tblOwner_Email_Pri")
.dtePickerEditPri.Value = Rs.Fields("tblOwner_BeginDate")
.(many more text fields) etc.
End With
When I run this procedure I get an error stating that the datepicker control
is ReadOnly and therefore I don't get the database field displayed in the
control on the form.
I have checked all the properties and am unable to find how to turn off read
only.
What am I doing wrong.
Any assistance will be greatly appreciated.
name, address, etc.
What I want to see is the datepicker control to display the acquisition date
of the lot owner of a community.
This date is a field in the lot owners table.
In the form open code I have a query that opens a record set that includes
the acquisition of the lot date field.
Set Rs = db.OpenRecordset(strSQL, dbOpenDynaset)
With Me
.txtEditPriTeleSec.Value = Rs.Fields("tblOwner_Telephone_Sec")
.txtEditPriEmail.Value = Rs.Fields("tblOwner_Email_Pri")
.dtePickerEditPri.Value = Rs.Fields("tblOwner_BeginDate")
.(many more text fields) etc.
End With
When I run this procedure I get an error stating that the datepicker control
is ReadOnly and therefore I don't get the database field displayed in the
control on the form.
I have checked all the properties and am unable to find how to turn off read
only.
What am I doing wrong.
Any assistance will be greatly appreciated.