Have Combo Box Default First Record

Cdogg

Registered User.
Local time
Today, 23:50
Joined
May 20, 2001
Messages
30
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
 
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")
 

Users who are viewing this thread

Back
Top Bottom