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

Use a Check Box to Update a Table with Text

P: 1
I have created an Access database that is designed to send an E-Mail
out to a new student's advisor using a Mail Merge. As part of this database, I have created three tables. The first table assigns an ID number to each
advisor based on campus. The second table assigns an ID number to each active degree program in the system. The third table takes the ID numbers from these first two tables and creates a list of the programs each advisor is assigned to. Example: Let's say that Joe Schmoe is the advisor for all Computer Science and Psychology students attending the Freedonia Campus. Joe's ID number is 1, and the ID numbers for the Computer Science and Psychology programs are 10 and 15, respectively. That means, the third table looks something like this:

ID Contact E-Mail ID Academic Program ID
1 1 10
2 1 15

Well, my program works beautifully. The problem is, I want to make it
easy for someone else to update the third table. The easiest method that I've been able to think of is if I could somehow create a form that has the advisors' E-Mail addresses listed with a bunch of checkboxes underneath each name that correspond to each major. Then, if you check a box, it updates a corresponding field on a fourth table (see below) that, through a series of append queries, could be used to update my third table.

ID Contact E-Mail BS.CS BS.PSY
1 10 15

Now my problem is, I can't figure out a way to make it so that when I check the box that says "BS.CS" for Joe Schmoe, it puts a 10 in the BS.CS column of my fourth table. Does anyone have any suggestions? I'm honestly at my wits' end.
Mar 14 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
Did you try to make the ID field and the Program field in the third table "Lookup" fields ?

Just open the tabledefinition and (having the proper field selected) click the "Lookup" tab at the bottom. There change the type to a combobox and specify the query needed to extract the code and name.
Now the table (and defined new forms) will show a combobox where the users can select the appropriate value without knowing the ID.

Mar 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.