Problems with new record entry in subforms

[Neal H.]

Greetings,
I have created a form that has a subform within it. In
the subform, I need to be able to add new records,
however, I am not able to do so. The Subform is based on
a query and under properties I have "Yes" selected for
allow edits, allow deletions, allow additions, and data
entry. How do I create a new record within this form?
Thanks in advance!

 

[Arvin Meyer]

First try to add records in the underlying query. If the query isn't
updateable, you need to make it so (usually by adding the primary key of the
table you want to update).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks for your response Arvin. The query is not
updateable. I have added the field that is the primary
key to the query, but it is still not updateable. Any
other suggestions to be able to update the query/form?
Thanks for your help!
Neal

 

[Armen Stein]

Thanks for your response Arvin. The query is not
updateable. I have added the field that is the primary
key to the query, but it is still not updateable. Any
other suggestions to be able to update the query/form?
Thanks for your help!
Neal

Hi Neal,

Another common reason for a query to be non-updatable is if is has
aggregate functions (like Sum, Count, Group By, etc.), or is joined to a
query that has these.

If this is the problem, you can compute these values by using calculated
fields on your subform, like this- ControlSource: =DSum("[fieldname]",
"[tableorqueryname]", "Where [fieldname] = " & [fieldname])

Also - you should probably turn off Data Entry. This forces the form
into a mode where ALL you can do is add new records - existing ones
won't display.

Hope this helps,
--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com