I have a weird problem (or I'm overseeing something plain). I have a form which I open in formview with a query as recordsource (set in the design view). On opening, depending on some condition, the recordsource may be changed to another query from code. This query contains all the same fields, except with different values.
Now the problem is that as soon as the recordsource changes, all the fields get locked, and it's impossible to add new records. It's like the AllowEdits, and AllowAdditions properties are set to false, but they aren't. I set a breakpoint just before the sub exits and checked the form and control properties. None of the controls are locked, and AllowEdits and AllowAdditions are set to true. Yet still I can't edit or add any records on the form. The exact moment this happens is when the recordsource is changed.
Can anyone explain what's going on?