Changing a Undateable Record - Custom Date Picker in Microsoft Access, Part 2


	Back to Custom Date Picker 2 Comments List

Changing a Undateable Record Upload Images Link Email

James Hopkins

5 months ago

Hey Richard and the Guys, if I use the 'DatePickerF' that Richard created in the 'Custom Date Picker Series' Tech Help to Reschedule Events. But the 'Schedule Information Form' that I am using to View the Scheduled Event Data has an Datasource of an Query that is Not Updateable. So, If I sent "SomeDateField = GetDatePicker(SomeDateField)" to open the 'DatePickerF' to set the Default date in the 'MyDate' field.

	Adam Schwanz 5 months ago
You'll have to change it into like a SQL statement to update the record then requery your form afterwards, something like this but it may require more changes depending on your setup. `Dim MyDate MyDate=GetDatePicker(SomeDateField) UPDATE Table Set SomeDateField=#" & MyDate & "#"` Probably need some where criteria here too but I don't know what you have going on.

	James Hopkins 5 months ago
Oh okay, Adam... I was thinking Recordsets, but I will use that... Thank you, Adam... Ur the Best...

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Custom Date Picker 2.