Access 2003 forms/subforms question

0 Votes

Access 2003 forms/subforms question

I am using Access 2003.

I have a form containing student information that shows information from more than one table. I know I can create subforms to show some of this information, but the main trouble I have with subforms is that they are not searchable from the main form; I'm having trouble with that on my main information form but that's another thread.

I guess my question is: is it possible to pull information from more than one record source on a form without using subforms? The expression builder that I can access from the control source in properties for each text box seems to build an expression referencing a table that is not the control source for the basic form, but when I go into form view it still shows #Name? error in each box. The expression built is:

=AssetInfo![English Score]

where AssetInfo is a second table and English Score is a field in that table. Main record source for the form however is CounselingData. Text boxes referencing this table of course show up fine.

I hope this made sense to someone besides me, if not I'll be happy to provide more information.