|06-24-10, 02:03 PM||#1|
Join Date: Oct 2005
Location: Chicagoland, once a year in Poland
Anyone know Access Well? Need help with "RecordSource"
Ok, I have this report
All fields are from loans table. There are name fields, Assigned to and Opened by.
current recordsource is "Loans"
and this expression for comments is working fine: =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
when I try to add business phone from contacts table, access ask me If i want the business number to be displayed for Assigned to or Opened by contact name fields.
Correct choice is Assigned to, when I pick it report recordsource changes from "Loans" to FROM Contacts RIGHT JOIN Loans ON (Contacts.ID = Loans.[Assigned To]);
With that change to recordsource, the comments Expression breaks, and displays error message.
If i set recordsource back to "Loans", then Business Phone displays error message.
How can I fix this?
Windows 8 the next big failure, right after Windows ME
|06-24-10, 08:41 PM||#2|
Join Date: Mar 2004
Re: Anyone know Access Well? Need help with "RecordSource"
Does this help?
Sorry nekro, I don't really know Access.