previous record

[fabiobarreto10]

In VBA, as I refer to a field value from the previous record in a subform.

 

[Vassago]

Are you asking a question?

 

[fabiobarreto10]

Yes, thank you

 

[sparks80]

It is not clear what you are trying to ask. Can you restate the question?

 

[fabiobarreto10]

okay.


I have a subform with four fields: step, the scheduled date, place and date rescheduled date.

By changing the field step, I need to identify the value of the field held the previous record date.

Thank you.

 

[fabiobarreto10]

okay.


I have a subform with four fields: step, the scheduled date, place and date rescheduled date.

By changing the field step, I need to identify the value of the field held the previous record date.

Thank you.

 

[fabiobarreto10]

I tried DLookup, but did not work:

DataAnterior = DLookup ("[DataRealizada]", "TblPassosStatus", "[CodPassosStatus] = Forms! [FFiltros]! [CodPassosStatus] -1")

Where did I go wrong?

 

[boblarson]

Try this instead:

DataAnterior = DLookup ("[DataRealizada]", "TblPassosStatus", "[CodPassosStatus] = " & DateAdd("d", -1, Forms![FFiltros]![CodPassosStatus])
 
 
'If it is a date then you probably will need the octothorpes
 
DataAnterior = DLookup ("[DataRealizada]", "TblPassosStatus", "[CodPassosStatus] = [B][COLOR=red]#[/COLOR][/B]" & DateAdd("d", -1, Forms![FFiltros]![CodPassosStatus] [B][COLOR=red]& "#"[/COLOR][/B])

You don't include the form reference inside the quotes. You concatenate it in. But I prefer using the DateAdd function to get my date rather than just subtracting which is why I used that. Hopefully this will work for you.

 

[fabiobarreto10]

It really is a date. I got it. I just added the name of the subform:

DataAnterior = DLookup("[DataRealizada]", "TblPassosStatus",
"[CodPassosStatus]=Forms![fFiltros]![subTblPassosStatus]![CodPassosStatus]-1")

I'll also try with the code you sent me. Thank you for help.