Can't Edit When Data Based On Expression

[shylock]

I have record set that populates a continuous form. I want to be able to edit the contents of any row on the form. Especially the dates and times. However, I get an error stating that since the date and/or time data is based on an expression, it can't be edited. I have tried DateValue, TimeValue and formatted the Date and Time text boxes as Short Date and Short Time, respectively, without altering the BeginDate and EndDate field in the query. CDate Will not work as it delivers the date with the time. Does anyone have any suggestions on how I can enable editing? The populated form and query are shown below:

SELECT TOP 50 DowntimeEvent.DowntimeEventID, Format(DowntimeEvent.BeginDate,"MM/DD/YYYY") AS ["Begin Date"], DowntimeEvent.BeginDate-Int(DowntimeEvent.BeginDate) as ["Begin Time"], Format(DowntimeEvent.EndDate, "MM/DD/YYYY") AS ["End Date"], DowntimeEvent.EndDate-Int(DowntimeEvent.EndDate) AS ["End Time"], DowntimeEvent.Description, DowntimeEvent.Planned, DowntimeEvent.ReportedBy, DowntimeEvent.ServerName
FROM DowntimeEvent
ORDER BY DowntimeEvent.BeginDate DESC;

[Bob Fitz]

Can you post a copy of the db with just a few dummy records to illustrate the problem

[June7]

A calculated field is never editable.

Use Format property or InputMask property. I use InputMask: 99/99/"20"00;0; For time try InputMask: 99:99\ L"M";0;

Users have to type the / or : if they don't enter 2 digits for each part.

The Date Picker will not be available.


Don't include quote marks in alias name construct, should be just: AS [Begin Date]. Advise no spaces nor punctuation/special characters (underscore only exception) in names. However, since you should not be constructing these calculated fields to begin with, moot point.

[CJ_London]

in order to be able to edit the control (and save the changes) the control needs to be bound to a field in a table. In your case date and time (one field) are separated into two controls - if you edit the field as a date, you lose the time element and edit the time, you lose the date element. If this was a single form, It would not be an issue, you would have two unbound controls one for date and one for time and then combine the two before the record is updated. But that won't work with continuous forms.

So I think you have two options:

1. Split the time element out and store in a separate field, adding them together as and when required
2. have a separate single form (which could be a subform to the continuous form header or footer) for editing the data - you can set the link child/master properties so it displays the current record selected in the continuous part.