Displaying results of an SQL query in a Textbox

Hi All

I've got a form where I'm trying to display the results of an SQL query in a textbox by clicking a button. See code below that I'm trying but doesn't work, not geting an error messages the result just isn't displaying in Text51 when I Click the FindCommission_Ref button. The result I want is the Comissioning_Ref from the Comossioning table and will be got from 2 comboboxes(Combo27 & Combo31) where Commissioning.Doc_Ref = Commissioning.Vehicle_No

Please Login or Register  to view this content.

Any help would be much appreciated on this

Donal