Form/Subform Save problem

[JimboUK]

I have a main form with one subform in it. The problem I'm having is that when closing the main form (as in an update) all records on main form save to table. The subform is a record that is in another table and I cannot get it to update to it's table. I understand that when you close a form in AC97 that it automatically updates the table. How would I get the data in the subform to save to it's table? Tried DoCmd and it won't update the table from the subform. ANy help appreciated.

Jim

 

[Ally]

Just to make sure - are the text boxes on your subform bound to the correct field, or do they say "unbound", when you look at them in design view?

 

[JimboUK]

Text boxes in subform are bound fields.

Jim

 

[Ally]

Not sure why they wouldn't be saving then. Are you able to post a zipped copy of db?

 

[IMO]

How is the subform linked to the main table? Have you Linked Child/master fields?

IMO

 

[Pat Hartman]

If the subform fields are all filled with default values or values entered via code, the Dirty property was never turned on so Access doesn't think it needs to save the record. Is this your situation?

 

[JimboUK]

Thanks Pat that sounds like it wa smy problem. had some default values in their and removed them and its working fine now. Thanks for all the ideas.


Jim