Go Back   nV News Forums > Software Forums > General Software

Newegg Daily Deals

Thread Tools
Old 06-24-10, 01:03 PM   #1
I'm Geralt
Join Date: Oct 2005
Location: Chicagoland, once a year in Poland
Posts: 24,366
Default 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
nekrosoft13 is offline   Reply With Quote
Old 06-24-10, 07:41 PM   #2
Join Date: Mar 2004
Posts: 15,488
Default Re: Anyone know Access Well? Need help with "RecordSource"

Does this help?

Sorry nekro, I don't really know Access.
ViN86 is offline   Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT -5. The time now is 05:25 AM.

Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Copyright 1998 - 2014, nV News.