setvalue help

  • Thread starter Thread starter Neal0o via AccessMonster.com
  • Start date Start date
N

Neal0o via AccessMonster.com

I am building a Employee Training Tracker . I want to use setvalve to
automatically populate the Hours for each class based on which Course is
selected in the Combo Box. The sngHours Field in the
tblAOGAnnualTrainingCourse table has the hours predetermined. I have the
following table

tblAOGAnnualTrainingCourses

with fields

IDAnnualTraining
AogAnnualTraining
sngHours

I built a form with a combo box (after update) to run macro1. I have
really no experience with Macros. Here is the test macro

item:[Forms]![Form1]![HOURS 1] this is an unbound Text box. I have tried
bounding the txt box also.
expression : [tblAogAnnualTrainingCourses]![sngHours] This is not working.
..

I would like it to set the value in the text box based on the combo box in
the form. By looking up the course in the tblAOGAnnualTrainingCourses and
setting the value in the forms text box. Thanks a million!!

Neal
 
Use the reference for the combo box in the Expression property:

Expression: [Forms]![Form1]![ComboBoxName]
 
Back
Top