Get data into textbox from related table via query 1

[ZOR]

I am using a listbox to get a fields content via query

SELECT TXMASTERS.ID1, TXMASTERS.SportorSports AS Sport
FROM TXMASTERS
WHERE (((TXMASTERS.ID1)=[forms]![Courses].[Form].[ID1]));

On cyling records, the listbox fills with a single particular value from a related table. I am wanting to capture the content of the listbox value.

Is there a way to get this via a dlookup method. I have no experience of Dlookups so I don't know if this is the correct road. Many thanks

 

[PWise]

try
me.textbox = me.listbox

or

me.textbox = me.listbox.column(x)

 

[ZOR]

Sorry, I was not as clear as I should. Is there a way to get this data without using a listbox/query. Regards

 

[PWise]

dlookup("TXMASTERS.SportorSports","TXMASTERS","TXMASTERS.ID1=" & [forms]![Courses].[Form].[ID1])

 

[ZOR]

Thats it, perfect. Many thanks, another star. Regards