SQL problem

[Tom123456]

If I want to run a sql query from a dropdown list that says a number, in this case a employee id, and I want the result to show in a textbox. How do I implement it?

I have the the sql query (Is a SUM query so itr only return one answer) ready but I dont know how to return the value to show up in a textbox.





- Tom

 

[jrbarnett]

In the drop down lists afterupdate event procedure

Me.TxtTextbox = DSum (Equivalent of your SQL query)

John

 

[Tom123456]

Thanks a lot!, of course!



- Tom