I have created a subform to be used for filling service/product details out, ready for invoicing.

It's very similar in design/use to the form 'Order Details Subform' that can be found within Access's example database 'Order Entry'.

The problem I'm experiencing is this, everytime I try to select a service/product from this subform, whether it's from within the parent form or if I open the subform seperately, I keep getting a 'Field cannot be updated' message.

Tech(ish) Details:
The selection is made from the subform in datasheet mode, with the use of a combo box.
Once you select the service/product required (ServiceID) the cost field is supposed to be updated accordingly using the After Update event of the ServiceID combo box.

I've triple checked all field parameters (names/types/sizes/formats...) to make sure everything matches what it's supposed to, I've made sure none of the updating fields are locked but it still comes up with that infernal message, 'Field cannot be updated'.

Has anyone got any advice/suggestions as I'm nearly at the point of putting fist through monitor!!

Thanks in advance for any light shed,

Simon

In your subform, go to the properties and make sure that the Allow Edits, Deletions and Additions is marked as "yes". Record Locks should be set as Edited Record. Data Entry should be set as "No".

[This message has been edited by Carol (edited 03-09-2000).]