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

2132

What can you do with access 2010 data?

567

What is record in ms access?

604

How many columns are in access?

562

What is the function of access?

604

How to create a simple query in ms access 2013?

587

What is the advantage of ms access?

570

What's the difference between access and excel?

609

What has replaced microsoft access?

676

How do I create an access database from multiple excel files?

496

The long and short date option in ms access does not show 4 digit years. How would you achieve the mm/dd/yyyy format?

564

What is an access macro?

624

What are the four objects in microsoft access?

621

How you can export data in excel format?

631

How would you create a report using the report tool and report wizard?

599