I've attached an Access database. When you open the database, please open the form. You'll see 3 comboboxes. Select the following values from the comboboxes:
combobox1 : AAAA
You'll see the subform gets populated with the value $850. How do I populate the textbox with that value? I want to use a textbox to display the result instead of a subform. I DO NOT WANT TO USE DLOOKUP TO DO IT. DLookup always has a noticeable delay in displaying a result and I can't stand it.
Another question: Going back to the subform, why does my merely changing the default view from Datasheet to Single Form cause the database to fail? Even if I try to then change it back to Datasheet view without having made any other changes whatsoever, it still fails. Can somebody explain why? Thank you.