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

2316

Who uses access database?

817

Can you put an access database on sharepoint?

810

How do you create a database in microsoft access?

882

How do I start microsoft access on my computer?

857

What is dao recordset in access?

896

What do you use microsoft access for?

796

Is it possible to automate the ms access database through menu driven selections? If yes, how?

828

Explain the primary key?

796

Do accountants use microsoft access?

797

What are the basic features of ms access?

979

What are the advantages of microsoft access?

888

What is microsoft access table?

789

What is the difference between microsoft excel and microsoft access?

848

How do you create a table in microsoft access?

785