Help needed with subforms-can't enter new data

[Guest]

I think what I want to do with my database is getting too complicated for me.
Any help or suggestions are appreciated.

I have a database with two tables, one is ComplianceActivitiesTracking, the
other is CorrectiveActionPlanTracking. I am trying to create a form that
will show only compliance activities that have a check mark in field
CorrectiveActionPlanRequired, but show a subform to data enter into the
CorrectiveActionPlan fields.

I created the main form based on a query of the ComplianceActivitiesTracking
table showing the following fields:
ActivityTrackingNumber (primary key/autonumber)
StartDate
ActivityOwner
CorrectiveActionPlanRequired (criteria:Is Not Null)
ActivityTitle
Description
StatusofActivity

The subform record source is the CorrectiveActionPlanTracking table, and
includes the following fields:
CAPID (primary key)
ActivityTrackingNumber (foreign key?-set up as the many side of one to many
rel)
Finding
RecommendationID
Recommendation
CorrectiveActionPlan

I want the main form fields to be view only, but users need to be able to
data enter corrective action plans. Things seem to be working, except that
new records in the subform can't be entered. Existing records show and can
be edited, but new records can't be entered. The new record button is greyed
out.

What am I doing wrong? Should I not use a query as a record source for the
main form? Thanks for your help!

 

[Van T. Dinh]

Check the AllowAdditions Property of the Subform and make sure that it is
set to Yes/True.

 

[Guest]

I think what I want to do with my database is getting too complicated for me.
Any help or suggestions are appreciated.

I have a database with two tables, one is ComplianceActivitiesTracking, the
other is CorrectiveActionPlanTracking. I am trying to create a form that
will show only compliance activities that have a check mark in field
CorrectiveActionPlanRequired, but show a subform to data enter into the
CorrectiveActionPlan fields.

I created the main form based on a query of the ComplianceActivitiesTracking
table showing the following fields:
ActivityTrackingNumber (primary key/autonumber)
StartDate
ActivityOwner
CorrectiveActionPlanRequired (criteria:Is Not Null)
ActivityTitle
Description
StatusofActivity

The subform record source is the CorrectiveActionPlanTracking table, and
includes the following fields:
CAPID (primary key)
ActivityTrackingNumber (foreign key?-set up as the many side of one to many
rel)
Finding
RecommendationID
Recommendation
CorrectiveActionPlan

I want the main form fields to be view only, but users need to be able to
data enter corrective action plans. Things seem to be working, except that
new records in the subform can't be entered. Existing records show and can
be edited, but new records can't be entered. The new record button is greyed
out.

What am I doing wrong? Should I not use a query as a record source for the
main form? Thanks for your help!

as i understood it, the database is relational, that is the first table is
related to the second. actually, you don't need a query as a record source
for form. well, unless you need to restrict data from being viewed by users,
example would be processed data which should not anymore be touch especially
if it contains financial figures.

maybe then, that you haven't established the relationship between your
tables that is why data could not be entered.

i hope i have answered your query, anyway, just post if ever you have
clarifications.