By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 985 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Need to use a yes/no box on a form to drive a table update

P: n/a
Current problem deals with three tables in my database. The
"DOCUMENTSLIST" table has a one-to-many relationship to the
junction table (DOCUMENTS/PROJECTS) which, in turn, has a many-to-one
relationship to the "PROJECTS" table.

The tables have the following fields:
DOCUMENTSLIST DOCUMENTS/PROJECTS PROJECTS
Document ID (P key) Documents/Projects ID (P key) Project ID (P key)
Type Project ID (F key) Project Name
DID Number Document ID (F key) Project Type
Document Name Responsible Officer Organization
Required (Y/N box) Preliminary Date `Comments
----- Draft Date POCs ID (F Key)
----- Final Date -----
----- Comments -----

Structure of the primary form: The PROJECTS table drives the main form
and displays the project name, project type and organization. I then
want to use a documents tab on the primary form to display information
related to specific documents associated with the project. There are
many documents which would potentially apply to a given project and the
DOCUMENTSLIST table lists all possibilities. I have placed a command
button on the documents tab subform to pop-up a form listing all the
documents with a yes/no box beside each to allow a user to select those
documents that apply to the specific project. This form populates the
"Required" y/n box in the DOCUMENTSLIST table. This table is then
used to drive a "documents_selected" query to get the list of just
the applicable documents.

I plan to put a command button on this pop-up form to run a macro which
will:
A) update the DOCUMENTS/PROJECTS table with the documents selected.;
B) clear the checked boxes on the pop-up form so the next user has a
clean form to work with.
C) Close the pop-up document selection form.

The issue: How do I make the DOCUMENTS_SELECTED query update the
DOCUMENTS/PROJECTS table? Have looked through this newsgroup and
haven't found the answer that I think will let me do this. Any help
anyone can provide will be much appreciated.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.