Saving New Data in a subform in Access

[moascar]

Can anyone help. I am trying to create a database in Access of exam results for students. The data has been imported from Excel about the students, and their results - fine so far.

I have a form for students where I want to show student details and a sub-form in datasheet view which shows their results. Fine so far.

If I want to add another exam result to the subform for a particular student the data is not accepted, yet I have seen other databases where this type of entry is permited.

I am not an confident or experienced user of Access, so if you are going to reply please use non-technical language.

Thanks for any help!

 

[missinglinq]

In a form/subform setup the AllowAdditions/AllowEdits/AllowDeletions properties of the main form are inherited by the subform, so the first thing to do, in Design View, is to go into Properties- Data and check that these properties are set to Yes for the main form.

If these are already set to Yes, then you need to check the underlying Record Source for your subform. If you open the query (or table) that it's based on, can you add records to it? IF you can't add record here then the query is non-updateable. IF that's the case here's Allen Browne's short paper on the reasons behind this:

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