troubleshooting Question

Display results of a query in a textbox

Avatar of dbfromnewjersey
dbfromnewjerseyFlag for United States of America asked on
Microsoft Access
7 Comments2 Solutions417 ViewsLast Modified:
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
combobox2:     1111
combobox3:     F

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.
Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros