Subform is Displaying a Table

[Rlmccants]

Hi people!

I've created a subform on a tab control, but when I switch from design view to form view, it shows a data table instead of the form that has just been designed.

Does anyone have any ideas as to why this is happening?

Thanks

 

[Galaxiom]

Is the problem in the subform when you switch the main form to Form view?
Have you set the Default view of the subform to your requirement?

 

[missinglinq]

It's not showing a "data table," it's showing the form in Datasheet View, which is the usual type of form used for subforms. In the form the subform is based on, goto

Properties - Format

and set the Default View to whatever you want Single View, if you want one record at a time to show, or Continuous View if you want multiple records to show in the way that you designed the form in Design View.

 

[ntanh72]

It sometime happen when you have form name the same with table name. In the design windows of subform you will see it says "table.tablename", make sure that it is written"form.someformname"