PDA

View Full Version : combo boxes for data entry



mindpeace
06-10-2006, 12:46 AM
Dear all ,
I very new to access ..hope u will help me ?.
I have created database of transactions ?.each transaction is belong to some person who is member of certain group ?so I have made reference table for that combination and given combination ID ?.
Id person groups
1 A AA
2 B BB
3 A BB
4 B AA

so the id that is number is mention in transaction table?
Date ID Transaction
5th may 1 456
6th may 1 464
5th may 2 67

for data entry I want to create an form with dependant cascading combo boxes of person and group and I want that every transaction should pick up ID based on those combinations ..
please help me to solve this

OBP
06-10-2006, 02:20 AM
For us to help you we really need you to post a zipped copy of the database on here using the "advanced" post option and "manage attachments".
If you want a combo box to "Add" names (or ID) to records then just create a query with the id, name and group and sort them by Name and then by Group.
Use the query to supply the data for your combo and you will have each person listed with their groups.
If you want two combos one for names and a second with groups based on the chosen name, you will need a second query fro the second combo and set it's criteria for the name column = to the 1st combo selection.
The first combo selection would have to use VB to "requery" the second combo to "pick up" te selected name.
The second combo would be "bound" to the "ID" field on the form.