Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2295 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain replication manager.
Explain about Microsoft access?
What is the use of ms access 2007?
What is the function of ms access?
Is access included in office 2019?
What is the function of access?
What is ms access and features?
Is ms access hard to learn?
What are the 6 major components of microsoft access?
What is dao recordset in access?
Versions of softwares change everyday. In what format should I save my database so that different versions of ms access cab open it?
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY will wrote in "thousand" box FIVE will be in "hundred" box and THIREE will be in "ten" box...... so, in sort i need to know that how can i do module for this that it appears automatically in perticular boxs...thanks
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
