We have 3 different tables that we want to link using last_name, first_name and middle_name as primary keys. We've created a query by doing 1 to 1 links between each table for the 3 keys listed above and then populated the query so that last_name, first_name and middle_name are only displayed once.

The problem is that when we link the query to the form through the record source, the form appears blank only in 'form view' not in 'design view'.

When you open the query in Datasheet view, is it populated?

I have seen other posts in the forum where if the relational integrity is set up wrong, or if there is a chance that the corresponding record won't appear in all tables, forms won't get populated correctly. But I can't offer any more specifics than that.