setvalue help

  • Thread starter Neal0o via AccessMonster.com
  • 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
 
K

Ken Snell \(MVP\)

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

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

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

Auto populate a Bound Text Box ACCESS 2003 3
how to setvalue in check box 7
How to setvalue of comboboxes to null 1
SetValue Condition if Null 4
Setvalue function not appearing in macro definition 1
Where did the SetValue action go? 5
how to setvalue in check box using macro 1
Setvalue from a Table Row 2

Top