creating reports from query from form field

[chrisrach3]

I'm in commercial real estate and I have two forms I use: 1) Listing Leads and 2) Listings. I have around 50-100 leads for each listing I have, and I have about 20 listings, and I'm trying to click the "report" button on my "Listings" form and have it bring up all of the leads for that particular listing that's shown on the form. I have a "Listing Leads Query" that I use for the report.



It worked GREAT before I switched from 2010 to 2007 (long story) but for some reason the code didn't adapt correctly. Any ideas? Here's what I currently have under the "where condition":

[Reports]![Listing Leads Report]![Property Name]=[Forms]![Listings]![Property Name]

Thanks
Chris

[June7]

What happens - error message, wrong results, nothing?

Where do you have this criteria - in a query or code? Show complete SQL statement or the code procedure.

[chrisrach3]

What happens - error message, wrong results, nothing?

Where do you have this criteria - in a query or code? Show complete SQL statement or the code procedure.

Ah, sorry. It brings up the report just great, but it doesn't populate it with anything whatsoever. Here's the code:


Option Compare Database

Private Sub Form_Open(Cancel As Integer)

End Sub


Private Sub ProspectName_AfterUpdate()

[Listing Leads].Email = ContactsQuery.ProspectName.Column(2)

End Sub

[June7]

None of that code shown opens the report nor does it show the criteria expression. Just a line that saves data to a field. Does this form remain open when you call for the report to open? Probably need to commit the data edit to table by saving the record. Use: DoCmd.RunCommand acCmdSaveRecord.

Data is not committed until close form, move to another record, or run code to save.