Form Open Blank

[Lou_Reed]

The db file that I have attached, has two forms



EditPropPass
EditTelework

That only open as blank forms when opened from the Navigation window. I had this problem last week, the fix worked then. It does not work now.

How can I make these form open up and not be blank? When the open up via other forms, they are not blank.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

Both have record sources that don't return any records and don't allow new records to be created. That will make the form open blank. Where do you open it from where it will not be blank?

[jwhite]

EditPropPass: Your RecordSource has an inner join to tblPropertyPass - there are no records in this table
EditTelework: Your RecordSource has an inner join to tblTelework - there are no records in this table

And in both I don't see why you have included tblPersonnel a second time to return FullName as [Approver] - just bring down FullName again from tblPersonnel and alias it to Approver. But then again, why return the fullname twice?

[pbaldy]

And in both I don't see why you have included tblPersonnel a second time to return FullName as [Approver] - just bring down FullName again from tblPersonnel and alias it to Approver. But then again, why return the fullname twice?

You didn't notice it was joined to different fields?

[jwhite]

Well, pardon me.