Access Form visible in Design View- but completely blank in all other views

Question

I am trying to build a form based on several tables in my database.  I've tried it with the Wizard and not- both had the same outcome.

Here's what I see in design view:

Here's what I see in Form View:

Nothing. Nada.

1 There are no filters on.

2. All form view, allow datasheet view and allow layout view are all set to yes.
3. There are no error messages. 
4. I tried turning off auto resize, auto center and fit to screen as suggested in other areas.  No luck. 
5. I read the other treads on here with this problem and none of those solutions worked. 

Any suggestions abouthow to make this work.  Any form I try to make does this.  I've never had this happen beofre

Thanks

Pam

Answer 1

There are several issues here. First its not good practice to create a form based on multiple tables. Too often such forms may not display data. And that is probably the issue here. The form probably has not data in its recordsource.

So first, I recommend that you use a mainform/subform combination. The Mainform should be bound to the Participant table and then you should have subforms for the other two tables.

You should build your form piece by piece. First the mainform and make sure it works. Then build the subform as a separate form, make sure they work. Then embed each subform on the main form, in turn. Check that each works.

See if that helps, if not post back with any error messages and we can try other solutions.