Dlookup Help

[ty939]

Hi , thanks in advance to all

I have this dlookup that is suppose to get a date(NewValue) from a table(Audittrail) where FormName = frmactiondetails(this is a column in audittrail) and where actionID(which is on the form frmactiondetails) is a date.

=DLookUp("NewValue","[tblAuditTrail]","[FormName]='frmActionDetails' And ActionID=" & [Reports]![PATS_ACTIONID])

Any reason why I am getting an error?

 

[theDBguy]

Hi. Not sure I understood your description. Can you maybe post a screen image?

 

[CJ_London]

help to know what the error is - you say

from a table(Audittrail)

but are using

"[tblAuditTrail]"

 

[pbaldy]

I would add that this:

[Reports]![PATS_ACTIONID]

probably needs to be:

[Reports]!ReportName.[PATS_ACTIONID]

 

[ty939]

Im thinking, I am going about this all wrong. I need to get a date from frmAudittrail where formname is frm actiondetails. I attached an image

 

[plog]

Give us an example. Tell us what values are on your form and what value from that screenshot you expect returned.

 

[theDBguy]

Hi. In the image you posted, I don't see any "ActionID" column.

 

[ty939]

sorry for the late response.I was extremely busy yesterday.

As you can see on the two images, I need to create a where statement. RecordID = PatsActionID .So if those two are the same then I want the date on the column newValue