Combo Box Problem

[WembleyBear]

Hi

I have a combo box on one of my forms to select a users name from a table
called Users. On the form, for visual information only, I want to see some
other information about the user contained in the same table - Users. I have
used the following in an unbound text control on the form to show this:

=[UserName].Column(1)

This works fine and shows the data as expected from the next column in the
Users table. However, when I do the same for the next column using
=[UserName].Column(2), try as I might nothing shows, despite the fact that
there is data in that column. This also applies to the other columns in the
table when I try and refer to them in the same way - only the first column
shows. What am I doing wrong?

Martyn

Access 2000, Windows 2003 server over Citrix PS4


Martyn

 

[Maurice]

Did you increase the columncount from the combobox. Set the form in
designview look for the properties of the combo and set the columncount to 3
(or as many as you think you might need). After that set the columnwidths as
wel to something like: 1,2,2 (or ; depending on your regional settings).

hth

 

[WembleyBear]

Fixed!

Thanks Maurice, I'm obviously having one of those days!!


Martyn

Did you increase the columncount from the combobox. Set the form in
designview look for the properties of the combo and set the columncount to 3
(or as many as you think you might need). After that set the columnwidths as
wel to something like: 1,2,2 (or ; depending on your regional settings).

hth
--
Maurice Ausum

Hi

I have a combo box on one of my forms to select a users name from a table
called Users. On the form, for visual information only, I want to see some
other information about the user contained in the same table - Users. I have
used the following in an unbound text control on the form to show this:

=[UserName].Column(1)

This works fine and shows the data as expected from the next column in the
Users table. However, when I do the same for the next column using
=[UserName].Column(2), try as I might nothing shows, despite the fact that
there is data in that column. This also applies to the other columns in the
table when I try and refer to them in the same way - only the first column
shows. What am I doing wrong?

Martyn

Access 2000, Windows 2003 server over Citrix PS4


Martyn