Edit a query when it's being used as a subform.

[JEA]

Not sure if this question should be here or in the query forum, but here goes.

On my [Enter Hours] form, I have a query as a subform. I'm allowed to type in this subform and it updates the [Hours] table with what I type ([Hours] is the table that the query is run on).

I want to do the same thing on my [TrainingFrm], but it tells me 'This recordset is not updateable'.

I don't know why the first one does it, I can't find any difference between the two, but I want the second to be able to do it. Any ideas?

BTW, this is my first attempt at a DB, and it's a time sheet one to boot. I've nearly finished, just got to tidy up the training side of things, tweak the formating and do a couple more reports. I'm going to post it here once it's finished, but I'd be happy to hear any feedback on the whole DB. I'm going to use it as a stand alone (hopefully) with the [Main Menu] as the main menu, so start there.

Edit:
1st file is Access 2007
2nd file is Access 2000

 

[JEA]

Could it be because on my [TrainingFrm] The perameter for the query is on the main form. If I was allowed to change the subform it would effect the queries results, therefore I can't do it.

I'm thinking this because on the [Enter Hours] form I don't try and change the query perameter in the sub form.

Is any of this making any sense?