Sign Up Login


  1. Categories >> Software >> Databases >> MS Access
  2. Suggest New Category

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

Question Posted / ed

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MS Access Interview Questions

How do you create an access file?

0 Answers  

What is the purpose of ms access?

0 Answers  

In MS Access the long and short date option does not show 4 digit years. how do I achieve the mm/dd/yyyy format?

0 Answers  

Versions of softwares change everyday. In what format should I save my database so that different versions of ms access cab open it?

0 Answers  

How are queries run in ms access? List different ways.

0 Answers  




How do you create a simple access database?

0 Answers  

Can you put an access database on sharepoint?

0 Answers  

What are the major advantages of dbms software applications such as microsoft access?

0 Answers  

What is the most important object in an access database?

0 Answers  

Can an access database be used online?

0 Answers  

how to u retrieve all tables along with all the data

1 Answers   Satyam,

Is microsoft access being phased out?

0 Answers  

For more MS Access Interview Questions Click Here
Categories