Form result output to report??

[poetdi]

Hello!
I am trying to get a form result (after a lookup) to output to a report of just the record returned. The person I am working with is a little better than I am at writing expressions and here is what she has written in the query:

[Forms]![Form_SampleData]![FLeadLook].[AfterUpdate]

No error is returned, but the report returns no record.

Are we approaching this completely from the wrong direction?
Thanks
Diane

 

[VicRauch]

AfterUpdate is an event for a field or record in connection with a form. If you want the data in the field FLeadLook to be used as the criteria for which record to get, then remove the .[AfterUpdate] and you will be a lot closer to getting this to work. I'm assuming that the Forms!Form_SampleData!FLeadLook is what has been put into the Criteria row of the query.

 

[poetdi]

Thank you so much for your reply, Vic. I took out .[AfterUpdate] and the query works, at least! I now have a button on the form, which calls the report, to fix and I think it will work. I will reply later or tomorrow if I get stuck again. Thanks for your help!!!