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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using DLookup on a query to set value on AfterUpdate 3
WHERE clause returns A and B, but not A and C 4
Form Query 5
Access 2 Digit year in Access Text Box 3
Need to Alter My Query 3
tearing my hair out 3
Invalid attempt to FieldCount when reader is closed 1
Normal Form-Second(Mr.Vinson?) 5

Back
Top