Go Back   nV News Forums > Software Forums > General Software

Newegg Daily Deals

Reply
 
Thread Tools
Old 06-24-10, 02:03 PM   #1
nekrosoft13
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, 08:41 PM   #2
ViN86
 
Join Date: Mar 2004
Posts: 15,486
Default Re: Anyone know Access Well? Need help with "RecordSource"

Does this help?
http://www.bigresource.com/MS_ACCESS...-Qws54D7x.html

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


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 04:45 PM.


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