Auto populate a Bound Text Box ACCESS 2003

[Neal0o via AccessMonster.com]

I'm working on a Training tracker for my company. I have a combo box that
allows me to
select from 21 Annual Training courses. see below:

Control Source:
[Training Course 1]

SELECT tblAogAnnualTrainingCourses.IDAnnualTraining,
tblAogAnnualTrainingCourses.[AOG ANNUAL TRAINING],
tblAogAnnualTrainingCourses.sngHours FROM tblAogAnnualTrainingCourses;

I am also tracking the Time per course that is queried in the above example.

=[TRAINING COURSE 1].Column(2)

How can I make access actually write the =[TRAINING COURSE 1].Column(2)
"value" to the table?


I have until now had this set up with an unbound text box whichs works fine!
But when I use another unbound
text box to total ALL of the course Times on the form it doesn't work.
Looks like access is having problems
adding the two unbound text boxes to give a total. SO now I will try and
bound the intial " =[TRAINING COURSE 1].Column(2) " so that access will
understand a little better of what I am trying to SUM up. I just need access
now to write the value to the table. Please tell me this is possible!!


Thanks..
viva la Access Monster

Neal0o

 

[Douglas J Steele]

You shouldn't. That would mean you'd have data stored redundantly.

Create a query that joins the two tables so that you pick up the time from
its correct source.

 

[Neal0o via AccessMonster.com]

Getting the information is not the problem. ACCESS will not add two unbound
text boxes, rather than adding them, access only displays the value in each
hours.. This make sense? Thank you!!!

You shouldn't. That would mean you'd have data stored redundantly.

Create a query that joins the two tables so that you pick up the time from
its correct source.

I'm working on a Training tracker for my company. I have a combo box that
allows me to

[quoted text clipped - 27 lines]

Neal0o

 

[Douglas J. Steele]

Sorry, no. Your question makes no sense to me.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Getting the information is not the problem. ACCESS will not add two
unbound
text boxes, rather than adding them, access only displays the value in
each
hours.. This make sense? Thank you!!!

You shouldn't. That would mean you'd have data stored redundantly.

Create a query that joins the two tables so that you pick up the time from
its correct source.

I'm working on a Training tracker for my company. I have a combo box
that
allows me to

[quoted text clipped - 27 lines]

Neal0o