This seems to be something changed recently but perhaps I just didn't notice it before.
In short, data changes on a form make (some) subforms "locked".
I have a (non-continuous) form that is based on a Table linked from an SQL Table. The Table has an IDENT, that is not used, and an ArticleID Field. A (continuous) Subform is based on another Table holding prices also linked in from SQL Server. Originally the subform was populated using the usual linkin of the form properties so that access automatically showed the prices for each article as the user chose an article. All well and good and normal.
On the subform there's a combobox to select the price-gourp, a text box to enter the price and a button to add these unbound values into the table (per VBA but this is irrelevant.)
I'm fairly sure this has worked since as long as I can remember but now, it doesn't. As soon as the main form gets dirty (any change in the bound article data) the subform is "kind of" disabled. "Kind of" means that the subform looks completely normal, no field is grey, the button is not greyed, and as the mouse cursor moves over the textfield it turns into the caret. However, the combobox can't be droppeddown, the textbox doesn't take the focus and the button can't be pressed.
Anyone know how to fix this?
I thought, "OK, the problem is Access might think I'm changing the key field and so stops anything bad happening by deactivating the linked Subform." Unfortunately no. I removed the link between the two forms and used code to ensure that the subform just shows the records from the selected article and, no change. The slightest change in the Article form blocks the pricetable subform.
Any ideas or links to knowledge *why* this is and how to fix it?
Many thanks in advance,
Andrew
Tidak ada komentar:
Posting Komentar