Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    183

    Unhappy Unanswered: help to display name not the ID

    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 = ""
    Else
    szBuilderName = Forms!frmLocation_BuildingWorks!.cboBuilder
    End If

    It gives me the ID of the record not the builders name and I need name.

    Could somebody help me with that please.

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    PHP Code:
      If IsNull(Forms!frmLocation_BuildingWorks!.cboBuilder) = True Then
        szBuilderName 
    ""
      
    Else
       
    szBuilderName Forms!frmLocation_BuildingWorks.cboBuilder.Column(1)
    End If 

  3. #3
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    183
    I didn't thank you, yes I realized that as well, completely forgot about it,don't do access too much.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    No problem, main thing it functions by You, Good luck, don't access Acce$$ much too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •