Form NOT visible in MS access 2007 form view!

3zzi32008 · 6th June 2009

Hi again to everyone, SOMEBODY PLEASE HELP ME!!!!

This is driving me mad, I have searched endlessly on Google for someone else who is having the same problem but they all differ slightly.

I have created a form in access 2007 with fields from about 4 different tables through the form wizard. After completed this, I can see all of the fields when in desin view, but when I switch to form view or layout view, the only thing visible is the header!!!

I have made sure that all tables related to this form have data in them, and I have made sure that the "Details" visibility is set to 'yes' under form properties but this isn't making the slightest bit of difference!!!

Am I missing something blindingly obvious?!?!?!?!

I have been going round in circles and an desperate for a point in the right direction.

Any help would be greatly appreciated

Many thanks, in advance.

twomack · 30th June 2009

I am having this same problem in Access 2003, however 03 users have no problem viewing the form, only 07 users. They can see other forms within the database, there is just one that is causing problems.

3zzi32008 · 1st July 2009

I think that you may have to create a form based on a query instead of creating a form by pulling fields straight from the tables.

Create a query, using all fields you wish from the various tables and then create a form from this query.