Problem adding a new row to a form.

  • Thread starter Thread starter Trevor Briggs via AccessMonster.com
  • Start date Start date
T

Trevor Briggs via AccessMonster.com

I've followed previous threads that cover a similar problem, but I've hit a
roadblock.
I have a form built over the following query:

SELECT Models.TitleID, Models.SubjectID, Models.[Manufacturer ID], Models.
[Sequence No], Models.[Serial No], Models.Material, Models.Scale, Models.
[No Parts], Models.Size, Models.Comments, Models.Possess, Models.Checked
FROM Subjects INNER JOIN Models ON (Subjects.SubjectID = Models.SubjectID)
AND (Subjects.TitleID = Models.TitleID)
ORDER BY Models.TitleID, Models.SubjectID, Models.[Manufacturer ID],
Models.[Sequence No];

I can add records to this query in datasheet view. The form has
AllowAdditions set to Yes. But I can not add records to the form.

I have another form based on this more complicated query (including a Left
Join) which works just fine:

SELECT SubjectRefs.TitleID, SubjectRefs.SubjectID, SubjectRefs.Source,
SubjectRefs.Issue, SubjectRefs.Page, SubjectRefs.Narrative,
SubjectRefs.Colourpic, SubjectRefs.Monopic, SubjectRefs.By,
SubjectRefs.Episode, Episodes.Title
FROM Subjects INNER JOIN (Sources INNER JOIN (SubjectRefs LEFT JOIN
Episodes ON (SubjectRefs.TitleID = Episodes.TitleID) AND
(SubjectRefs.Episode = Episodes.Episode)) ON Sources.[Source Code] =
SubjectRefs.Source) ON (Subjects.SubjectID = SubjectRefs.SubjectID) AND
(Subjects.TitleID = SubjectRefs.TitleID)
ORDER BY SubjectRefs.Issue, SubjectRefs.Page;

I'm at a loss to know why I can add rows to the query, but not to the form.

Thanks in advance for any help.
Trevor Briggs
 
Do you have "Data Entry" set to "Yes" in the data property?

Hanksor
Growing old is mandatory, growing up is optional.........
 
I didn't, but changing this to "Yes" didn't help. Also, the form that works
also has this property set to "No'. By the way, bothof these are actually
subforms. I don't know if that makes a difference.
 
What is the Recordset Type property value for the form? It should be
Dynaset.

When you say you can't add new record, do you mean it shows the blank row
but won't let you enter data? or it doesn't show the blank row at all? can
you click the >* button on the navigation buttons?

Give us a bit more details about "can't add record".
 
Yes, the Recordset Type property is set to Dynaset.

When I click on the > button nothing happens, and I cannot enter data into
any of the fields.

I've just noticed something else. If I bring up the form on its own, it
appears to work. But when I invoke it as a subform I get the reported
problem.

Could it be something to do with the way the form and subform are linked?
 
I've cracked it.

The subform definition had the "Locked" property set to "Yes". Changing
this to "No" corrected the problem.

By the way - changing the "Data Entry" property to "Yes" had no effect on
this problem, but it did prevent all the existing records from displaying
and only allowed new records to be added. Just a FYI for the earlier poster.

Thanks for all your help guys - what a great resource this is!

Trevor
 
Back
Top