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 recordset type in access?
Is access difficult to learn?
What do you mean by erd and its main elements?
What is a null value in access?
How do you link data in access?
How do you change data in access?
Is access good as a database?
Which is better mysql or ms access?
How many types of relationships are there in ms access?
What is autonumber in ms access?
Is there a substitute for microsoft access?
Explain about the various features present in MS Access?