Form not visible

[LHWC]

I have an Access 2007 DB with 8 tables, see attachments. I created a form, using the wizard, to enter article info. I want to capture info for all the fields in tblArticles and the product mentioned and the publication. I chose the ProductName field in tblArticleProduct and the PubName field in tblArticlePublisher. This created a query, see SQL attached.
I see the fields in design view, but not in form view. What's wrong?
Thanks in advance

 

[LHWC]

Sorry, not familiar with box.net. Try these.

 

[missinglinq]

Controls don't appear in Form View when two conditions exist at the same time:

There are no records in the underlying recordset

and

The form cannot have records added to it

Several things can cause a Form to not be updateable:

AllowAdditions is set to No.

RecordSet Type Property is set to Snapshot

It is based on a Query, where data comes from two or more tables, and the Query is Read-Only.

Read-Only Queries is explained clearly by Allen Browne:

http://allenbrowne.com/ser-61.html

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[LHWC]

Thanks for the reply, missinglinq.
There are no records in the recordset.
Allow additions is set to yes.
RecordSet Type is Dynaset.
The query comes from 3 tables. This is the SQL that the wizard built:

SELECT tblArticles.ArticleName, tblArticleProduct.ProductName, tblArticlePublisher.PubName, tblArticles.ArticleDate, tblArticles.Writer, tblArticles.AdValue, tblArticles.ArticleSize
FROM (tblArticles INNER JOIN tblArticleProduct ON tblArticles.ID = tblArticleProduct.ArticleName) INNER JOIN tblArticlePublisher ON tblArticles.ID = tblArticlePublisher.ArticleName;

I'm thinking its read only: Joins of different directions?

Here's the structure of the tables involved:

tblArticles fields
ID (PK)
ArticleName
ArticleDate
Writer (FK to tblWriters.ID (PK))
AdValue
ArticleSize

tblArticleProduct fields
ID (PK)
ProductName (FK to tblProducts.ID (PK))
ArticleName (FK to tblArticles.ID (PK))

tblArticlePublisher fields
ID (PK)
PubName (FK to tblPublisher.ID (PK))
ArticleName (FK to tblArticles.ID (PK)

So, I'd like a form to enter info when an article is published. I want to capture ArticleName, ArticleDate, Writer, Publisher, ProductName (clients product reviewed), ArticleSize and Advalue (choices of which are in the tblPublisher.)
Do I have the table relationships wrong, or is something else going on?

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886