RE: [MS_AccessPros] Error Message Help

 

Thanks John! I made the combo box unbound as directed and its working.

 

Bill Beshlian

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, March 24, 2014 2:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Error Message Help

 

 

Bill-

 

A "lookup" combo box should NOT be bound to any field on the form.  If there is a Control Source defined, you're updating (or attempting to update) the current record every time you choose a new value to search.  Make sure your search combo box is not bound.

 

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

 

 

 

On Mar 24, 2014, at 8:00 PM, <william.beshlian@alegent.org> <william.beshlian@alegent.org> wrote:

I created a form and a sub-form (in Access 2010) which are linked by the Job Code (as the Master field) on the main form and the similar field (as the Child field) on the sub-form.  I have created a one to many relationship (Enforcing Referential Integrity, Cascading Updates and Cascading Deletes) between the tables used for the main and sub-form.  Using a Dropdown box in the main form as the control to retrieve the related data in the sub-form works as I expect.  When I close the form the following Information/Error box appears,” The changes you requested to the table were not successful...or redefine the index to permit duplicate entries and try again."  I am not making any changes on either the main or sub-form.  What would cause this? And, how do I prevent this in the future?  I have not run across this when I have done similar work in previous versions on Access.  Thanks in advance,

 

Bill Beshlian

 

---

The information contained in this communication, including attachments, is confidential and private and intended only for the use of the addressees. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you received this communication in error, please inform us of the erroneous delivery by return e-mail message from your computer. Additionally, although all attachments have been scanned at the source for viruses, the recipient should check any attachments for the presence of viruses before opening. Alegent Creighton Health accepts no liability for any damage caused by any virus transmitted by this e-mail. Thank you for your cooperation.

This electronic mail and any attached documents are intended solely for the named addressee(s) and contain confidential information. If you are not an addressee, or responsible for delivering this email to an addressee, you have received this email in error and are notified that reading, copying, or disclosing this email is prohibited. If you received this email in error, immediately reply to the sender and delete the message completely from your computer system.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (9)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___