I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

0 Answers  

---

What is the way to link the explicit data into access database?

0 Answers  

---

Is access difficult to learn?

0 Answers  

---

Tell some of the most important uses of ms access?

0 Answers  

---

What is the size limitation for an access database?

0 Answers  

---

Does microsoft 365 come with access?

0 Answers  

---

How can we create a simple query in ms access?

0 Answers  

---

If you know "Access", you can capture data from "Excel" broadsheet, but the limitation is that, a memo data type of "Access" can only hold characters upto- (a)31,000; (b 32,000; (c)33,000; (d)34,000.

1 Answers   Wipro,

---

Is microsoft access important?

0 Answers  

---

How do I create a database in access 2007?

0 Answers  

---

What is a domain in microsoft access?

0 Answers  

---

Can access be used as a crm?

0 Answers  

---