Forum home » Delegate support and help forum » Microsoft Access Training and help » Control Source in Forms
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Control Source in Forms
Resolved · Low Priority · Version 2002/XP
Reply Wed 4 Aug 2010, 11:34Delegate Sarah said...
Sarah has attended:
Excel VBA Intro Intermediate course
Access Advanced course
Access Intermediate course
Control Source in Forms
Can I refer to two seperate tables as my control source in one form?
For example, I have some fields in a form that I've taken from one table called tblDemographics and then I want to use on the same form a couple of fields from a different table called tblRecords
For upcoming training course dates see: Pricing & availability
RE: Control Source in Forms
Hi Sarah,
Thank you for your question.
The answer is yes. As long as the tables are linked in terms of primary and foreign keys.
If the tables are linked you can do it through the Form wizard taking fields from both tables.
If you have already created a form based on one of the tables, then you would add a Text Box(Unbound control) and set the Control source using the expression builder in the properties sheet.
I hope this helps.
Regards
Simon
Mon 16 Aug 2010: Automatically marked as resolved.
|