Combo Boxes with Queries - Microsoft Access Beginner 5


	Back to Access Beginner 5 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Combo Boxes with Queries

Tammie Barr

4 years ago

In my query I am pulling the studentid and studentname from the first table, then from the second table I am pulling the teachersname and classname. The query does what I need it to do however it shows the autonumbers assigned to teachername and the classname. Is there a way to show the teachers name and the classname. In the forms this information is picked with a combo box (we have over 100 courses to choose from). Thanks!

	Kevin Robertson @Reply 4 years ago
Many To Many

	Tammie Barr OP @Reply 4 years ago
Thank you!

Scott Axton @Reply

4 years ago

If you are seeing the AutoNumber in the Combo Box you didn't shrink the id field -- hide it -- when you set
up your Combo.  You might want to watch the Relational Combo video again.  That shows you how to combine last name and first name and have it display in the combo.  Same theory to combine teacher and class.

You might also want to consider the  Cascade video.

If you had cascading Combo Boxes you could pick the teacher then only show that teachers classes or vice versa
choose the class then pick the teacher.  Just depends on what is most convenient for you.

	Scott Axton @Reply 4 years ago
You could edit the properties and change the widths of the fields in the combo if you felt comfortable but it's really just as easy to create it fresh.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 5.

Next Unseen

New Feature: Comment Live View