Thank you for answering my post yesterday. Would I put this in the Control Source of the text box I want it to dispay in? The expression you gave works if I use a client ID and delete the & "[Forms]![frmDashboard]![clientID] part. In other words, if I just use "ClientID=7". How would I get it to read the current clientID populating the rest of the form?
Or should I build a subroutine to run from the On Current property of the form. If I do that, how do I bound the text box to that? Thanks for the assistance.
Just a note, it's prefered if you post in the original post so that others can benefit from your experiences.
Want you want to do is put this in the control source of the text box you want it to display in. and, leave in the & "[Forms]![frmDashboard]![clientID]" part, this is what picks out the value of the client ID and refrences the Dsum to it.
It would help if you could post atleast the dashboard form so I can see exactly what you have named each control.