Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Combobox giving me a warning

Posted on 2014-01-08
3
Medium Priority
?
262 Views
Last Modified: 2014-01-10
I'm trying to select a record from a combobox on a form.  Suddenly it give me an error when I click the choice I want...

Update or canceupdate without addnew or edit

???
0
Comment
Question by:SteveL13
  • 2
3 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39765987
What code do you have associated with the combo box?
0
 

Author Comment

by:SteveL13
ID: 39768027
None.  But I tried something.  I added Me.Dirty = False to the afterupdate event of the field and the problem went away.  I don't understand what this is doing to make it work.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 total points
ID: 39768209
Strange - it sounds like your sombo box's row source might be dependent on the same table(s) as your form  (Just a guess).
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Implementing simple internal controls in the Microsoft Access application.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question