Newbie Question = Setting Text Box Value onChange

  • Thread starter Thread starter Access Newbie
  • Start date Start date
A

Access Newbie

Hi,

I have a simple form with 2 fields.

"JobType"
Populated by a query ( SELECT JobType.JobTypeID, JobType.JobType,
JobType.JobRate FROM JobType ORDER BY JobType.JobTypeID; )


The second field, "Rate", I need populated after I change the value of
"JobType".

I have tried building the code and here is the best I have got.

Private Sub JobTypeID_Change()
Me.Rate.Value = Me.JobTypeID.Recordset.JobTypeRate
End Sub

Thanks for any help.
 
Problem Resolved.
Thanks.

Private Sub JobTypeID_Change()
Me.Rate.Value = Me.JobTypeID.Column(2)
End Sub
 
Back
Top