Refresh Detail in Access

[teneesh]

The following code is not displaying the data that this statement is selecting on the Access Form. What's wrong with it? Thanks in advance.

Private Sub cbxEvaluatee_AfterUpdate()
sqltext = " select dbo.idtoname(i.eid)as evaluator, dbo.idtoname(i.evalteeid) as evaluatee,* from viewt120 v , evalissue i " & _
     " where v.evalrecno = I.RecNo " & _
    " and formno = 'T120'" & _
    " and evalteeid = " & Me.cbxEvaluatee
Debug.Print sqltext
    Me.Refresh
    Me.Detail.Visible = True
End Sub

[Delerna]

Where are you actualy executing the query?
and how are you connecting it to the form?

[missinglinq]

As Delerna has intimated, your code doesn't actually run your SQL statement. In point of fact you cannot run SQL SELECT statements from code in Access, only Action statements, such as APPEND, DELETE, UPDATE, etc. Where/how would Access display the results? To do this from VBA you'd have to run a stored parameter query, providing the required Evaluatee parameter.

Linq ;0)>

[Delerna]

Tenesh, you could say

Private Sub cbxEvaluatee_AfterUpdate()
sqltext = " select dbo.idtoname(i.eid)as evaluator, dbo.idtoname(i.evalteeid) as evaluatee,* from viewt120 v , evalissue i " & _
" where v.evalrecno = I.RecNo " & _
" and formno = 'T120'" & _
" and evalteeid = " & Me.cbxEvaluatee
 
 me.RecordSource=sqltext
 
Me.Refresh
Me.Detail.Visible = True
End Sub
 
 

to execute the select query on you form. I have bolded the change I made.

Of course the form would need to be able to handle the recordset returned. IE textboxes with their datasources set correctly etc.

[teneesh]

Where are you actualy executing the query?
and how are you connecting it to the form?

I was missing the:
me.RecordSource=sqltext,
I didn't realize it was required.

[NeoPa]

If items have beed added or removed from the underlying recordset then line #9 (Delerna's code) should be replaced by :

Me.Requery