Dirty Subform - Microsoft Access / VBA

Mark

Is this the way to determine if a subform is dirty?

If Me!SFrmEnterActivityList.Form.Dirty Then

I use this statement in the Unload event of a form. When I click the Close
button, the statement is always false whether I have made a change in the
subform or not.

Thanks!

Mark

Nov 12 '05 #1

Subscribe Post Reply

5243

MacDermott

"Mark" <mm*****@earthlink.net> wrote in message
news:Ue*****************@newsread3.news.atl.earthl ink.net...

Is this the way to determine if a subform is dirty?

If Me!SFrmEnterActivityList.Form.Dirty Then

I use this statement in the Unload event of a form. When I click the Close
button, the statement is always false whether I have made a change in the
subform or not.

Thanks!

Mark

Nov 12 '05 #2

MacDermott

If you are executing code on the form, chances are your focus has left the
subform.
Whenever your focus leaves the subform, the data in the subform is saved,
and its Dirty property becomes false.

HTH
- Turtle

"Mark" <mm*****@earthlink.net> wrote in message
news:Ue*****************@newsread3.news.atl.earthl ink.net...

Is this the way to determine if a subform is dirty?

If Me!SFrmEnterActivityList.Form.Dirty Then

I use this statement in the Unload event of a form. When I click the Close
button, the statement is always false whether I have made a change in the
subform or not.

Thanks!

Mark

Nov 12 '05 #3

Mark

Yes!! That's exactly what is happening. Thanks for pointing it out.

Mark
"MacDermott" <ma********@nospam.com> wrote in message
news:zh*****************@newsread3.news.atl.earthl ink.net...

If you are executing code on the form, chances are your focus has left the
subform.
Whenever your focus leaves the subform, the data in the subform is saved,
and its Dirty property becomes false.

HTH
- Turtle

"Mark" <mm*****@earthlink.net> wrote in message
news:Ue*****************@newsread3.news.atl.earthl ink.net...
Is this the way to determine if a subform is dirty?

If Me!SFrmEnterActivityList.Form.Dirty Then

I use this statement in the Unload event of a form. When I click the Close
button, the statement is always false whether I have made a change in the
subform or not.

Thanks!

Mark

Nov 12 '05 #4

Similar topics

How to reduce dirty page steals?

by: Sean C. | last post by:

Helpful folks, I am having a hard time figuring out how to reduce my percentage of dirty page steal activity. Below are statistics for three fairly normal days, with the bufferpool hit ratios...

DB2 Database

How to check if subform is dirty

by: Rey | last post by:

Howdy all. Appreciate your help with several problems I'm having: I'm trying to determine if the Visit subform (subformVisits) has a new record or been changed, i.e. dirty. The form that...

Microsoft Access / VBA

How to not trigger dirty event when initializing control on form through VB?

by: P | last post by:

Hi, I have a form with several controls. One of them is initialized through VB in frm_current. I am using the frm_beforeupdate event to prompt users for saving changes. How can I make it so that...

Microsoft Access / VBA

the dirty form!

by: Ray | last post by:

I have a subform which takes one of its fields from the main form, namely the YearLevel which is from 1 to 8. There is also another field which returns the year from datePart. If I select a...

Microsoft Access / VBA

Docmd.Runcommand accmdsaverecord vs Me.Dirty = False

by: Salad | last post by:

A97. I have a command button to save and exit. I had the code If Me.Dirty Then Docmd.RunCommand acCmdSaveRecord ...more code endif I was getting an error because a value was not getting...

Microsoft Access / VBA

Disable Me.Dirty Access 2002

by: RIP662 | last post by:

Okay all you GURUS out there... here's the skinny... I need a way to prevent the Me.Dirty event to trigger after a FORM_OPEN event. What I have is a field that is dependent on another field that...

Microsoft Access / VBA

Dirty Event for Form is not "firing".

by: Susan Bricker | last post by:

I am currently using the OnDirty event of a Form to detect whether any fields have been modified. I set a boolean variable. Then, if the Close button is clicked before the Save button, I can put...

Microsoft Access / VBA

Me.Dirty - Please help.

by: DanielM | last post by:

Please Help - If Me.Dirty I Understood That It Check If any Data in controls had changed. I Have a Form with few textboxes, and On Exit from the form i want to check if data was changed. But It...

Microsoft Access / VBA

Correct use of Dirty event

by: Ericks | last post by:

I have a subform that contains several controls of which one is a date control called “DateOfInfoAdded”. The default format of this control is date() so whenever a new record is created the date is...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice