Re: Logout idle users and discard changes

Hi Debra,

I would just use the Main Form's OnClose event.

Try out this to see if it works.

Me.Dirty = False
Forms!SubformName.Dirty = False
or
Forms!MainFormName!SubFormName.Dirty = False
or
Forms!MainFormName!SubFormName!Forms.Form.Dirty = False

Debscanadian wrote:
Access 2003
snip
My testing only checks the main form dirty property and I am lost as
to how to test the dirty property of a subform in a generic fashion.
Debra

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200703/1

.

Relevant Pages

  • Re: combo box that updates outside table and then needs to be requeried
    ... In the OnClose event of your data entry form, ... > I have a main form with about 6 tabs. ... On the subform, which is used to populate a table, is a combo ...
    (microsoft.public.access.forms)
  • Re: Subform - Add New Record
    ... >When I was using a pop-up form for dataentry, I could use the OnClose event ... >to check for saving. ... You can use the BeforeUpdate event of the Subform control. ...
    (microsoft.public.access.gettingstarted)
  • Re: Subform problem
    ... >that opens another form called [frm private companies]. ... the OnClose event of the smaller form is ... >contains the client name. ... >smaller form as a subform of the main form, with a button on the main form ...
    (microsoft.public.access.forms)