Use next record DateTime (StartTime) field data to populate the DateTime (EndTime) field

[rjackson]

I have tried using the DLOOKUP -

EndTime: DLookUp([LineInfo]![DateAndTime],"LineInfo",[LineInfo]![ID_Event]=" &   [LineInfo]![ID_Event]  + 1")

I have tried DLOOKUP on the same record and it works for integers, but I can't get a DateTime field to copy correctly.
The data structure is as follows: ID_Event - primary key AutoNumber, DateAndTime - Date/Time, Batch - Text, Event_ID - integer, EncodedEvent - integer,(Calculated field) EndTime.
After I tackle this I will need to use DateDiff() to calculate a duration field in seconds. Sure could use the help.
The final version uses an inner join on EncodedEvent to display the actual event (Decoded). This will output to a report and pie chart.

[Micron]

You need to wrap non numeric data types in their proper delimiters: " for text and # for dates.
Take a look here for some examples of using DLookup. Note that if using form controls in the function, you need to properly concatenate the control name and any required delimiters. The site shows delimited and control reference examples, but not a mixture of both, I believe.
BTW, your syntax is a bit more verbose than it needs to be. The examples