General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 2003 forms/subforms question
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.