Fields in Design View don't show up in Form view.

[WesternActor]

I'm using Access 2007, and trying to create a form that accesses data from multiple tables. I've created a query that pulls the data from those tables, and the form I'm using has that query set as a data source. When I go into Design View to put in the data entry fields, everything goes fine and I don't seem to have any problem adding them or arranging them. But when I switch to Form view to test the form, none of the fields appear--if I add an image in the header or the footer, or even that doesn't show up. This doesn't happen when I create a form from any of the tables I use in the query. Anyone know what the problem might be?

 

[Rabbie]

This link may be describing your problem

http://allenbrowne.com/casu-20.html

HTH

 

[missinglinq]

First off, please understand that we get posts from people whose experience ranges from little or none to decades of writing code, so don’t be insulted by the sometimes seemingly basic questions!

You say you created a query that pulls the data from your tables; have you actually run the query independently to confirm that it’s pulling the records?

You say that the form’s based on the query. I assume you mean that you’ve set the form’s Record Source to the query. Did you do this first then go to the Field List and click and drag the fields onto the form, or did you create the form with text boxes, then set the Record Source to the query? IF the latter, did you then go and set the Control Source for each textbox?

One of the most common reasons for controls not showing up is Data Entry being set to Yes and Allow Additions being set to No.

Is your form in Datasheet View per chance? In Design View for a Datasheet form you can put whatever you like in the header and footer sections and they’ll never show up in Form View!

Good Luck!

Linq