Various table sources on same form

[Don]

Can anyone tell me if there is a way to use fields from different tables on
the same form without using a subform. I have text boxes one after another
where a couple are from a different table. My form already has various
subforms on it, but for continuity, certain text boxes from different tables
need to be right next to each other. I've tried referencing the specific
table in the field's control source, but haven't had any luck. Any info
would be greatly appreciated. Thanks.

 

[Sandra Daigle]

You can do this if the tables are joined in the form's Recordsource query.
This works in some situations, in others it leads to slow queries and/or
queries that are read-only. What are the tables? How are these fields
related to the fields in the form's recordsource?

You might want to look into using a subform which appears as regular fields
on the main form. by removing the border, the recordselector, the navigation
buttons and setting the Cycle property of the subform to current record you
can actually achieve this without too much trouble.