How can we choose only column 2 from combo to be input

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

How can I choose only column 2 from my combox box that to be input on my
textbox.

Thanks for your help.
 
Anthony,

Thanks for your qucik response Anthony, the idea is like this:
In my member tabe I have field by the name "role" taken from Role table
using combo.

In the role table I have 1 Fields.
1 Role Id which is autonumber
2. role ( name of the role, like husband, wife, 1st sun etc.)

I already filled the role table according to the swquence, starting, from
husbund, wife...etc)

If I sort my member query by role, because it is text, it does not look like
what I expected, so I created again 1 field in the member table which name is
Role Sequence so that I can sort by this role sequence

But I have difficulty ( already filed all member role feld ( which is text).
I add in the form which is textbox name member Seq and it is invisible,
because this is just for the sake of sequence of role.

My question :
1. how can we choose only column 2 in my Role combo box
2. My statement Me![UrtRole] = Me!Role.Column(2) does not work

Thanks for your help
 
Back
Top