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
No Answer is Posted For this Question
Be the First to Post Answer
What is the use of ms access 2007?
What is microsoft access 2013 runtime?
What are the main differences between the two?
I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?
What is the difference between excel and access?
What is the main purpose of ms access?
What is a database access?
What are the important features of ms access?
Explain superior keys and candidate keys. How are they different?
What is access good for?
can primary key of one table be a primary key in many other tables
how to u retrieve all tables along with all the data