Hi there!
In my database I have an input form "PaySupplier_Bank" by which I put data to the table "PaySupplier_Bank" for payment to supplier through bank. While I fill up the form it helps to have a look of Supplier Balance and Consignment balance. That's why I have added two text boxes "ConsBal" and "SupBal". In these two text boxes I have used Dlookup function to fetch those balances according to "Cons_ID>" and "Supplier_ID>" fields that are chosen on the form. The "ConsBal" text box gets data from the query "ConsWiseBalance" and the "SupBal" text box gets data from the query "SuppWiseBalance". However, "ConsBal" is working but "SupBal" is not working. A little help is earnestly needed.
Furthermore my assumption was as the intermediate query "SuppWiseBillTotal" was made from "Cons" table where the field type was Combo box, I tried changing the query's "Supplier_ID>" field's Display control to text box, but still would not work. I am attaching the database.