Combo Box Form to Report - Microsoft Access Forum


	Back to Access Forum Comments List

Combo Box Form to Report

Beau Tanner

5 years ago

I have a combo box on my form that allows the user to pick which campus zone a particular building is located. I used two different tables to set this up: Campus Zone Table, and the building table. I didn't think about it at the time, but how do I translate this to a report? That is, the report is based off of the BuildingT which has a numerical value stored for the campus zone (picked from ExistCampusZoneT), so how do I get the text value of the campus zone to show up instead of the number value?

	Beau Tanner OP @Reply 5 years ago

	Beau Tanner OP @Reply 5 years ago

	Beau Tanner OP @Reply 5 years ago

	Adam Schwanz @Reply 5 years ago
Make a relationship in the query between the tables, or make an expression like ZoneFix: DLOOKUP("ZoneName","OtherTable","ZoneID=" & ZoneID) replacing your field names as appropriate

	Beau Tanner OP @Reply 5 years ago
This kind of makes sense to me. Is there a lesson video that I can watch?

	Adam Schwanz @Reply 5 years ago
I'm not sure, I know I've seen it in one of Ricks videos but I can't recall which one. It might not have even been a lesson about that, it may have just been a little tidbit that came along in the middle of another class. May be in one of the relationship or query videos, RICK MIGHT HAVE TO ADVISE WHERE IT MIGHT BE

	Beau Tanner OP @Reply 5 years ago
Thank you. I'm not very good with coding, and am learning on the fly as I build this project. I like having videos that breaks everything down Barney Style so I can follow along. That's one of the reasons I like Rick's videos.

	Richard Rost @Reply 5 years ago
If you can join the two tables together in a query, then just use grouping levels in your report. It's more efficient than a DLookup for multiple records.

	Richard Rost @Reply 5 years ago
Very similar to making an Invoice.

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

Next Unseen