Query Results to form Access 2003

[psullivan348]

Please someone help!

I need to get the results of a query to display on a form in a text box.

I have two columns of data, quarter and year to date. Once the user enters the quarter, I want the query to run, which total the quarters and then I need to populate the ytd fields with those results. I have tried many, many, many things but it just doesn't seem to work.

What is the best way to get query results into text box on form?

I have looked at so many different ways, and tried a bunch but none seem to work. Please help!

 

[HiTechCoach]

I can only think of two ways off the top of my head to do this:

1) Have you tried using the DLookup() function?

2) Have you tried using VBA code to open a recordset to get the Value?

 

[psullivan348]

I did try the dlookup but that does not seem to get me the right answer EVER!!!

I think that I have to do the recordset but I don't understand how I tell it to go to the blank text boxes. I have looked online and some one on a different forum gave me some code but it doesn't populate the boxes.

I am looking for some time of guidlines or instrustions in Northwinds but I can find anything.

Thanks