Add an entry using double click

[Guest]

I am building a Training data base for our organization. Since some of the employees attend the same training, I would like to be able to add the training class to the form and table by double clicking the "Training Type" box in the Training registration form.

 

[Graham R Seach]

A little more information might elicit a meaningful response. For
example,which form and which table do you want to add the training class to?
Where is information about the training class stored? In which type of
control is the training class displayed/selected?

You know about your own database - we don't.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I am building a Training data base for our organization. Since some of

the employees attend the same training, I would like to be able to add the
training class to the form and table by double clicking the "Training Type"
box in the Training registration form.

 

[Guest]

I have a table called Training Catalog and another table called Employees and from the two I have created a form called Training. I also have a table called Classes. I would like the Classes table to be used in the Training Form to select the the type of training. The idea would be that the class table could be edited by adding new training to the Training form from the classes form. I am thing that the classes would become a control source for the training table, However I am still learning Access. Thanks for any help you can offer

----- Graham R Seach wrote: ----

A little more information might elicit a meaningful response. Fo
example,which form and which table do you want to add the training class to
Where is information about the training class stored? In which type o
control is the training class displayed/selected

You know about your own database - we don't

Regards
Graham R Seac
Microsoft Access MV
Sydney, Australi

I am building a Training data base for our organization. Since some o

the employees attend the same training, I would like to be able to add th
training class to the form and table by double clicking the "Training Type
box in the Training registration form

 

[Graham R Seach]

OK, if I understand you correctly:

1. You want the Classes table to be used as the source for a combo box on
the Training form.
2. You want the Classes table to be editable from the Training form.

I'm afraid I don't understand what you mean by "...class table could be
edited by adding new training to the Training form from the classes form".
The phrase "...Training form *from the classes form*" is what throws me.

Dealing with the issues I can deal with at this point...
1. You can use the Control Wizard to setup the Classes combo when you create
the combo on the Training form. If you've already created it, then delete
it, enabled Control Wizard (on the Toolbox), and re-create it.

2. If by that you mean you want the user to be able to enter a value in the
Classes combo, and have that value added to the combo's source table, then
the following link will explain how to do that
http://www.pacificdb.com.au/MVP/Code/NIL.htm.

If you have any trouble doing this, then you'll need to provide us with a
list of the field names for all the tables involved (which includes their
relationships to each other), and a more detailed description of what you
want to do. We'll also need to know what's on the Training form and the
Classes form.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I have a table called Training Catalog and another table called Employees

and from the two I have created a form called Training. I also have a table
called Classes. I would like the Classes table to be used in the Training
Form to select the the type of training. The idea would be that the class
table could be edited by adding new training to the Training form from the
classes form. I am thing that the classes would become a control source for
the training table, However I am still learning Access. Thanks for any
help you can offer.