Recent content by Carl Colijn

An enormous thank you! That was indeed the simple fix I hoped someone could point me to. I hoped I only needed to change the backend databases though (like setting primary keys etc.), but this is the next best thing. Although "dynaset - inconsistant updates" always makes me afraid it'll mess...

The "error" doesn't appear in 2003 nor in 2007, but Access 2010 got more strict in when a recordset is still updatable, and that change of rules broke this functionality. Name being a reserved word didn't hinder in 2003/2007/2010 though, so that's a red herring here.

:) I've attached a sample database with the exact same code, but I thought adding all code in one place (it's not much) would clarify things a bit. I also already found the reason for this problem, so I added that as well so people wouldn't need to investigate first. Anyway, once you're in...

Hi all! TL;DR: I've got a bound combobox on my continuous form. The combobox is bound to a field from the form's record source (an ID field), but it shows data from a helper lookup query (based on a second table), that translates the bound ID field to a description value. It's thus showing...