View Full Version : Have Combo Box Default First Record


Cdogg
01-07-2002, 08:18 AM
I have a querry calulating a total. I would like to put the answer into a textbox if it can be done

If I can't do that, I could do it with a combo box but I would like to have the first record as default being there is only one record.

Thank you for your help

Jack Cowley
01-07-2002, 08:44 AM
If the query is a Totals query and the field is called Numbers then this as the Control Source of an unbound text box should give you your total:

=DLookup("SumOfNumbers","YourQueryName")