Results 1 to 6 of 6
  1. 09-18-2013, 08:13 PM #1
    Access_Novice
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265

    What is the difference between a Record Source and a Control Source?

    Based on what I have been reading online, they appear to be the same thing. Are they the same thing or different?
    Reply With Quote Reply With Quote
  2. 09-18-2013, 08:29 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    A RecordSource applies to a Form and a ControlSource applies to a Control on a Form.
    Reply With Quote Reply With Quote
  3. 09-18-2013, 08:33 PM #3
    Missinglinq's Avatar
    Missinglinq
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    The Record Source is the Table or Query (or SQL Statement) that contains the Records of a Bound Form.

    The Control Source is what a given Control displays. If it is a Bound Control, it displays a Field from the underlying Record Source. If is is Unbound, it can display the results of an Expression, Calculation or Function.

    Simply put, a Record Source relates to a Form, a Control Source to a Control. Form.

    Linq ;0)>

    Beat out by the Man of the Mountain!
    Reply With Quote Reply With Quote
  4. 09-18-2013, 08:45 PM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Quote Originally Posted by Missinglinq View Post
    Beat out by the Man of the Mountain!
    Maybe Linq but your explanation was more complete. I vote for your response over mine.
    Reply With Quote Reply With Quote
  5. 09-18-2013, 09:02 PM #5
    Access_Novice
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265
    Quote Originally Posted by Access_Novice View Post
    Based on what I have been reading online, they appear to be the same thing. Are they the same thing or different?
    Thank you all.
    Reply With Quote Reply With Quote
  6. 09-18-2013, 09:15 PM #6
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Glad we could help.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Help with Control Source
    By love2waltz in forum Access
    Replies: 1
    Last Post: 05-18-2012, 01:09 PM
  2. #Error in Control with a subform control source
    By alsoto in forum Forms
    Replies: 5
    Last Post: 10-13-2011, 03:36 PM
  3. Dlookup as Control Source
    By alsoto in forum Forms
    Replies: 1
    Last Post: 08-28-2011, 07:05 PM
  4. control source
    By nashr1928 in forum Forms
    Replies: 5
    Last Post: 03-12-2011, 09:31 PM
  5. Control Source
    By sarah54 in forum Access
    Replies: 1
    Last Post: 03-07-2011, 09:00 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums