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
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
