[MS_AccessPros] Re: Help with form always indicating Dirty

 

Glad I could help, Rod.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <desertscroller@cox.net> wrote :

Thanks Bill, found the issue, corrected and working great.  Thanks for the clues which pointed me in the right direction.

Rod

---In MS_Access_Professionals@yahoogroups.com, <desertscroller@...> wrote :

The unbound controls (2) are used to indicate the record number and the number of records being processed.  There are no fields with default values.  I have  not check the nulls or zero-length fields but will take a look at them today.

---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

Control before_update events are tricky. What is the purpose of the unbound controls?

Do you have any controls with default values? That might be triggering the before_update events.

When you check the old & new values do you check for nulls changing to zero-length strings?

---In MS_Access_Professionals@yahoogroups.com, <desertscroller@...> wrote :

Hi All, I have a form that in bound to a table (11 fields) and 2 unbound fields used to scroll thru the records.  Each time I move to the next record, the before_update event triggers.  I have examined the old and current values of the bound controls and no changes are indicated.  I have bound the controls to the table and also to a query of the table.  Same results.

Any suggestions?

Using windows 10 and ACCESS 2013.

Rod

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___