Hi All,

How do I populate Access query results in excel userform text fields?

For eg;

I have a Query: "SELECT Student_ID, Course, Grade, Qtr_ID" & _
" FROM Student_Info WHERE Student_ID = " & _
Me.StudentId.Value

Here Me.StudentId.Value is a text box in excel userform

And here is what the query results look like:

Student_ID Course Grade Quarter_ID
JP1124 Math A SP01
SP1164 Phy B SP01

Here "Student_ID, Course, Grade, Quarter_ID" are the column headers in Access

The userform looks like this:

Student ID: [ ]

Course Grade Quarter_ID

[ ] [ ] [ ]
[ ] [ ] [ ]
[ ] [ ] [ ]

So the query results will go into different textboxes [ ]

Hope I made it clear,

Thanks in advance



Thanks in advance