[AccessD] Subform not saved

David
How about

MsgBox Forms!frmCustInvoice!sfrCustInvoiceMeter.Form.Dirty

Or even

MsgBox Forms!frmCustInvoice.Form!sfrCustInvoiceMeter.Form.Dirty


Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> David Emerson
> Sent: 02 December 2003 04:35
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Subform not saved
> 
> 
> Group,
> 
> AXP FE / SQL2000 BE
> 
> I have a subform on a form.  I want to check if the record on 
> the subform 
> has been saved when the main form is closed.  I am having 
> problems with the 
> syntax.  If I use the following in the on unload event of the 
> main form -
> 
>          MsgBox Forms!frmCustInvoice!sfrCustInvoiceMeter.Dirty
> or      MsgBox Forms!frmCustInvoice!sfrCustInvoiceMeter.NewRecord
> 
> I get "
> 
> Object doesn't support this property or method (Error 438)"
> 
> However
> 
>          MsgBox 
> Forms!frmCustInvoice!sfrCustInvoiceMeter!txtPresMeterReadDate
> 
> returns the correct value so I know I am referring to the 
> subform correctly.
> 
> The reason for checking is that when the main form is being 
> closed by the x 
> in the top right hand corner, the after update event is not 
> firing on the 
> subform (yet the record is being saved!).  Another symptom is 
> that I need 
> to click on the record selector twice for the pencil to turn 
> into a triangle.
> 
> I am sure it is something to do with refreshing the record 
> from the SQL BE 
> but not sure how to fix it.
> 
> Any pointers?
> 
> Regards
> 
> David Emerson
> Dalyn Software Ltd
> 25 Cunliffe St, Churton Park
> Wellington, New Zealand
> Ph/Fax (877) 456-1205  
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>