Based on what I have been reading online, they appear to be the same thing. Are they the same thing or different?
What is the difference between a Record Source and a Control Source?
Competent Performer
Windows 7 64bit 
Access 2013
Based on what I have been reading online, they appear to be the same thing. Are they the same thing or different?
Administrator
Windows 7 64bit Access 2013
A RecordSource applies to a Form and a ControlSource applies to a Control on a Form.
VIP
Windows 7 64bit Access 2007
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!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Administrator
Windows 7 64bit Access 2013
Maybe Linq but your explanation was more complete. I vote for your response over mine.Originally Posted by Missinglinq
Competent Performer
Windows 7 64bit Access 2013
Thank you all.
Administrator
Windows 7 64bit Access 2013
Glad we could help.
Posting Permissions
Reply With Quote