Hello, I need help

Im working on an ACCESS form and I am trying to populate a text box with 2 fields from a recordset. I am trying to use a "For Loop" to do this and its not writing all the records in the recordset to the text box. It only writes the first record. The ESSN is used for employee social security number which is getting entered by the user typing it into txtSSN.

Here is my code:
myRS2.ActiveConnection = CurrentProject.Connection
mySQL2 = "Select ESSN,PNO,HOURS From Works_On Where ESSN=" & txtSSN
myRS2.Open (mySQL2)

'Write employee project(s) and hours to text field
For empCounter = 0 To myRS2.EOF
    txtWorkHrs = "Project" & myRS2("PNO") & "-" & myRS2("HOURS") & "Hours"
    myRS2.MoveNext
Next

Can anyone here help me with this and show me the correct way of doing this? It would be greatly appreciated. This is for a project that Im working on for my class in College.

Thank you for your time.
Eric

I may be understanding this wrong, but are you trying to add new records based on your recordset? if so, you'd probably be after something like this to replace your loop:

I am a loud man with a very large hat. This means I am in charge

Im not trying to add records.
Im just trying to populate the txtSSN text box with the records that match the Social security Number that the user typed in.

So basically im just trying to read the current record set and match the SSN that user gave to any records in the record set that match it.

In the text box I want to display ProjNo and Hours from that record set that match that SSN.

Im sorry if this does not make sense.

Have you tried stepping through your code in debug mode? This could help you determine if your for loop is actually looping through all the records. From what I see, here is my analysis.

You state the text box is populated with the data from the first record. This tells me your app is leaving the for loop after the first record. As your loop is written, I would expect to see the data from the last record in the text box. In order to build a list, you would need to construct your loop in a manner similar to the following:
HTH



Darrell L. Embrey

Darrell

Thank so much.
That worked. The problem was how originally had the loop set up. It was existing out of the loop after one iteration.

I understand it now.

Thanks for the help.
Eric

One of the rare occassions where I have the right answer.

Darrell L. Embrey