value not shown

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Orchid
    #1

    value not shown

    On my table I have ClientID with account#. The ClientID is a list box
    with row source selected from a table client info and is a combined
    fields of ClientID & ClientName, which has
    Bund Column: 1
    Column Count: 2
    Column Widths 0";2"

    The table works fine which shows the ClientName, and used as ClientID
    to link with other table.

    However, it doesn't work when I have it on a bound form. It shows the
    ClientID but Not the clientName.

    Could someone help me on how to make it show the ClinetName?

    You help is greatly appreciated!
    Tags: None
    • timmg
      #2
      Re: value not shown

      On Jun 8, 11:27 pm, Orchid <yhton...@yahoo .comwrote:
      On my table I have ClientID with account#.  The ClientID is a list box
      with row source selected from a table client info and is a combined
      fields of ClientID & ClientName, which has
      Bund Column: 1
      Column Count: 2
      Column Widths 0";2"
      You're ceding control of what's seen to Access - generally a bad
      idea. Remove the lookup from the table.
      >
      The table works fine which shows the ClientName,  and used as ClientID
      to link with other table.
      Yeah, for now, but it's going to cause heartache later on, trust me.
      >
      However, it doesn't work when I have it on a bound form.  It shows the
      ClientID but Not the clientName.
      >
      Could someone help me on how to make it show the ClinetName?
      See, what did I tell you? <g>

      Change to form's record source to a query with the necessary tables
      and fields - a much more powerful and flexible solution.

      HTH,

      tim mills-groninger

        Comment

        • Orchid
          #3
          Re: value not shown

          On Jun 9, 9:28 am, timmg <tmillsgronin.. .@gmail.comwrot e:
          On Jun 8, 11:27 pm, Orchid <yhton...@yahoo .comwrote:
          >
          On my table I have ClientID with account#.  The ClientID is a list box
          with row source selected from a table client info and is a combined
          fields of ClientID & ClientName, which has
          Bund Column: 1
          Column Count: 2
          Column Widths 0";2"
          >
          You're ceding control of what's seen to Access - generally a bad
          idea.  Remove the lookup from the table.
          >
          >
          >
          The table works fine which shows the ClientName,  and used as ClientID
          to link with other table.
          >
          Yeah, for now, but it's going to cause heartache later on, trust me.
          >
          >
          >
          However, it doesn't work when I have it on a bound form.  It shows the
          ClientID but Not the clientName.
          >
          Could someone help me on how to make it show the ClinetName?
          >
          See, what did I tell you? <g>
          >
          Change to form's record source to a query with the necessary tables
          and fields - a much more powerful and flexible solution.
          >
          HTH,
          >
          tim mills-groninger
          Thanks for your help. I changed to using a query instead of a table.

            Comment

            Previous template Next
            Working...