View Full Version : One form two recordsources


Skip H
10-09-2000, 09:31 AM
Hi Everyone,
Using Access/2000.
I have a form, which displays student id, class, teacher, etc.
On the same form I want to display the student’s name into a text-box, which comes from another table.
The tables are StudentCurrentData, StudentMaster, both have Student ID as primary key.
How can I do this without using a subform.
Thans in Advance
Skip H

lamha
10-09-2000, 09:42 AM
Make a query from these 2 tables, then set your form RecordSource to this query.