Field updates the next?

[Mark Bratanov]

I have two fields that im trying to create a report off of:

1. Name
2. Box

They are linked together by a Primary Key called ID. I have two tables called Employee_Info, and Main_Data - They are designed in example below, continue down for rest of question.

Employee_info
+------------------------------------+
| ID | NAME |
+-----+-----------------------------+
| 1 | Bob Jennings |
+-----+-----------------------------+
| 2 | Etc..... |
+-----+-----------------------------+


Main_info
+------------------------------------+
| ID | Box Number |
+-----+-----------------------------+
| 1 | 1 |
+-----+-----------------------------+
| 1 | 2 |
+-----+-----------------------------+
| 1 | 5 |
+-----+-----------------------------+
| 2 | 1 |
+-----+-----------------------------+


I want to have to 2 combo boxes, the first one is Name, selecting all the names in Employee_info. I want to have it so when I select the name, it updates the second combo box to all the boxes that specific person has, since they are all different. If you can help me i would REALLY appreciate it. Thank you so much for your time!!

 

[Andy]

Mark;

Go to Microsoft.com and search for:
Q209595 - ACC2000: How to Synchronize Two Combo Boxes on a Form

Takes a little time and work, and You will have to change the Table's
Primary Key Data Type to text, but it works.

Andy

I have two fields that im trying to create a report off of:

1. Name
2. Box

They are linked together by a Primary Key called ID. I have two tables

called Employee_Info, and Main_Data - They are designed in example below,
continue down for rest of question.

Employee_info
+------------------------------------+
| ID | NAME |
+-----+-----------------------------+
| 1 | Bob Jennings |
+-----+-----------------------------+
| 2 | Etc..... |
+-----+-----------------------------+


Main_info
+------------------------------------+
| ID | Box Number |
+-----+-----------------------------+
| 1 | 1 |
+-----+-----------------------------+
| 1 | 2 |
+-----+-----------------------------+
| 1 | 5 |
+-----+-----------------------------+
| 2 | 1 |
+-----+-----------------------------+


I want to have to 2 combo boxes, the first one is Name, selecting all the

names in Employee_info. I want to have it so when I select the name, it
updates the second combo box to all the boxes that specific person has,
since they are all different. If you can help me i would REALLY appreciate
it. Thank you so much for your time!!

 

[Mark Bratanov]

Thanks for your reply and time! I appreciate it.

Mark;

Go to Microsoft.com and search for:
Q209595 - ACC2000: How to Synchronize Two Combo Boxes on a Form

Takes a little time and work, and You will have to change the Table's
Primary Key Data Type to text, but it works.

Andy



called Employee_Info, and Main_Data - They are designed in example below,
continue down for rest of question.
names in Employee_info. I want to have it so when I select the name, it
updates the second combo box to all the boxes that specific person has,
since they are all different. If you can help me i would REALLY appreciate
it. Thank you so much for your time!!