[sharonme]

(using Access 2002)

Hi. I'm trying to "beef up" one of the Access general templates for use, and I'm running into a problem.

I'm using the "Contacts Management" template, and have added a field "ReferredBy" to the Contacts table. I was wanting to add this as a search item on the "Report Date Range" form, so that I can have a report organized not only by date but grouped by ReferredBy.

I hope this makes sense, I am experienced with Access but not very experienced with Visual Basic. I've done a ton with MySQL, and thought this would be related. I guess I'm wrong... ;-)

I've been able to add the ReferredBy to the Report Date Range form. However, I get an error:

Run-time error '2465': Microsoft Access cannot find the field "|" referred to in your expression.

The VBA for the Report Date Range looks like this:

Private Sub Form_Open(Cancel As Integer)
Me.Caption = Me.OpenArgs
Me![Referred By] = [ReferredBy]
Me![Beginning Call Date] = Date - Weekday(Date, 2) + 1
Me![Ending Call Date] = Me![Beginning Call Date] + 6
End Sub

Everything works fine when I don't have the "Referredby" line in there, but it does nothing with that item... The way the code is now, it seems circular, but my brain can't figure out how to fix it.

If you would like to view the file, the location is sharonedmonds.com . Simply add the file name to the end of the url to download the db (same file, one is zipped): CustMgmt.mdb or CustMgmt.zip

Please help. I am so frustrated and just looking for a little help, even just where I need to go to get help.

Thank you!

[sharonme]

Ok, so now it looks like the problem isn't in the form, but in the report I'm trying to make.

I've updated the database to include dummy entries, so that you can see the lack of organization in the report.

1. Download http://www.sharonedmonds.com/CustMgmt.zip
2. Click "Preview Reports"
3. Click "Preview the Weekly Call Summary Report"
4. Select a loan officer and a date (at least 1 week).
5. The report pops up, organized by person, but it doesn't seem to process the "loan officer" item from the previous form.

How in the world do I change this??? I'm so confused...

[MustBNuts]

By what you've written, you've added the field to the table, but you probably have not added the field to the query that the report is pulling.

In the report's design view, take a look at the report properties, it will tell you the source of the data (table or query)...I suspect it's being populated by a query.

Go to the query it references and add your field there too.

Hope this helps,

MBN