Insert querie in a textbox

[JoanaSantos]

how can i run a querie and insert the result in my textbox?
the result only have one field:

fec_data
21/04/2015


the query is a union between two tables(select)
INSERT INTO Balancetes_data ( fec_data )
SELECT DISTINCT T_MES.fec_data
FROM T_MES INNER JOIN BALANCETES ON T_MES.Fec_Data = BALANCETES.Fec_Data;


with vba code please

 

[1DMF]

DLookup perhaps?

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[dhookom]

You query is an action query that doesn't return a value. You can use domain aggregate functions like DLookup() or DMax() to query a single value from a table or query.

You can also use the Concatenate() function faq701-4233 to return a single value from an SQL statement.

Duane
Hook'D on Access
MS Access MVP