Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Query

Status
Not open for further replies.
Aug 17, 2000
23
US
Hello,

I have 3 tables. Department, Requirements, and Training.
(The Requirements table joins the Department and Training)
I created a form that has a combobox containing Departments
that shows relevant Training titles in a subform.

I would like to create a cmd button to open a popup form
to show all of the Training titles. The Popup will serve
as a way to add and delete Training titles from the
Departments.

...What follows is my Popup form:

I have a select query based on the Training table. The
training table contains a yes/no field as a selector.

...I created a form based on the qryTable.

How do I capture selected check marks and then update
the tables so that when I switch back to the main form
the changes reflect.

I hope my explanations was simple enough. Your help would
greatly be appreciated! Thanks...

GodofSmallThings




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top