I have a list of templetes and an access database and word document templates are grabing data from the dababase and feeding into those fields,all of that is working fine but one field.
That field is a combo box,and this is the Row SourceELECT DISTINCT [List Of Builders].ID, [List Of Builders].NAME, [List Of Builders].SUBURB FROM [List Of Builders] WHERE [List Of Builders].Name IS NOT NULL ORDER BY [List Of Builders].Name
Obvioulsy I am not hiding the ID and displaying the builders name,company and suburb.
On the other hand when I try to grab builders name to be printed by using this code:
'* Getting builders name
If IsNull(Forms!frmLocation_BuildingWorks!.cboBuilder ) = True Then
szBuilderName = ""
szBuilderName = Forms!frmLocation_BuildingWorks!.cboBuilder
It gives me the ID of the record not the builders name and I need name.