Form is blank in design and layout view

supersezzie

Registered User.
Local time
Today, 07:30
Joined
Mar 29, 2013
Messages
10
Hi,

Can anyone help with this? I have read all over the internet but am still drawing a blank! My form was working fine but when I added an extra tab it started showing as completely blank in design view. When I deleted the tab I had added I still was left with the same problem!

Please help! I've attached an image of the form properties in case that sheds any light on it. I want to use the form to enter data so it needs to show even if there are no records.

I had read that it could be if there is no data but typing data in the tables hasn't worked either.

Thanks for any help folks!

Sezzie :)

:confused:
 

Attachments

  • Form Properties.jpg
    Form Properties.jpg
    83 KB · Views: 133
can you show your complete record source - starts SELECT [Student Det...
 
Hi,

It's a long record source! Here it is:

SELECT [Student Details].*, [Disability Information].StudentID AS [StudentID_Disability Information], [Disability Information].[Issues / Conditions], [Disability Information].Formal_Diagnoses, [Disability Information].Medical_Evidence, [Disability Information].DDA, [Disability Information].DSA, [Disability Information].Session_Prompts, [Status and Follow Up Actions].StudentID AS [StudentID_Status and Follow Up Actions], [Status and Follow Up Actions].Status, [Status and Follow Up Actions].Follow_Up_Due, [Status and Follow Up Actions].Notes AS [Notes_Status and Follow Up Actions], [Status and Follow Up Actions].Complete, [Student Appt Log].StudentID AS [StudentID_Student Appt Log], [Student Appt Log].Date_of_contact, [Student Appt Log].Length, [Student Appt Log].Notes_Written, [Student Appt Log].Evision, [Student Appt Log].Starting_Score, [Student Appt Log].Ending_Score, [Student Appt Log].Notes AS [Notes_Student Appt Log], Tasks.StudentID AS StudentID_Tasks, Tasks.Title, Tasks.Priority, Tasks.Status AS Status_Tasks, Tasks.Description, Tasks.Start_Date, Tasks.Due_Date FROM ((([Student Details] INNER JOIN [Disability Information] ON [Student Details].StudentID=[Disability Information].StudentID) INNER JOIN [Status and Follow Up Actions] ON [Student Details].StudentID=[Status and Follow Up Actions].StudentID) INNER JOIN [Student Appt Log] ON [Student Details].StudentID=[Student Appt Log].StudentID) INNER JOIN Tasks ON [Student Details].StudentID=Tasks.StudentID;

It uses data from about 5 tables.

Also, I have looked at the link suggested in another post to the Allen Browne page (I'm not allowed to post links yet!) but within the scope of my understanding, I think I have done all the steps to no avail.

Thank you for your help! It is VERY much appreciated! :)
 
The chance of a Form with a RecordSource involving 5 Tables being anything except Read-Only is very remote! Don't know what article of Allen's you're referring to, but he has an excellent one here that explains the ins and outs of this:

Why is my query read-only?

Chances re you'll need to rework this, using one Table per Form, and then use the Forms to set it up data entry using a Main Form/Multiple Subforms scenario.

Also, having the Data Entry Property set to Yes, despite its name, isn’t necessary to enter data! It means that you cannot view existing Records, you can only enter New Records, which may or may not suit your needs.

Linq ;0)>
 
Thank you! I don't know if this is a bad move or not but I've resolved it by creating a tabbed form with a subform on each tab! I'm a complete newbie so it was very good to know, thanks :)
 
Actually, that's pretty much the standard approach for this sort of thing!

Good luck with your project and let us know if you need more help!

Linq ;0)>
 

Users who are viewing this thread

Back
Top Bottom