Head fudge over Combo Box

[battenberg]

Hi, I think there is a very simple answer to this but it is giving me brain ache!!

I have a form which displays or edits 'projects', this form is bound to the projects table

each project record is assigned a location, that location is selected from a combo box.

When the Location is selected in the combo box it stores the 'Numerical' value to the [location] field in the projects table.

my question is this:
how do i create a query as a base for a report that will list projects by location but give the location name (as it appears in the combo) rather than its numerical value as stored in the table?

I keep getting a 'type mismatch' error

I just cant get my head around it!!

 

[RuralGuy]

You need to join the table with the Location to your projects table in the query.

 

[battenberg]

Colorado Rockies eh!, big mountains - lots of snow!!!

Thanks for the reply, but i just cannot get it to work...

tblProjects
ProjectID
ProjectName
ProjectRef
ProjectLocation

tblLocation
LocationID
LocationName

above is an exapmle of the fields: which ones do i join?

I get a mismatch if i join tblProjects[ProjectLocation] to tblLocation[LocationName]

and i get strange results if I join the ID fields...

 

[battenberg]

sussed it... something stupid!!!

location table was a 'Number' field
ProjectLocation was a 'Text' field.

feel really dumb now....

 

[RuralGuy]

See how much wiser you have become?

 

[battenberg]

thank you OB1 .....