how to change codes from combo box to tex box with row source (1 Viewer)

C

Casperaprel

New member

Local time

Tomorrow, 00:18

Joined

Nov 21, 2019

Messages

8

• Nov 21, 2019

• #1

Hi, i'm asking how do i convert it from combo box item to list box

example my combo box control source is "IDSUMARRY '' and my row source is" SELECT tblProgram.ID, tblProgram.Project
FROM tblProgram;
"

how to convert to a text box. TQ

 

Attachments

• 
  examplejpg.jpg

  49.5 KB · Views: 46
• 
  example 2.jpg

  94.9 KB · Views: 40

theDBguy

I’m here to help

Staff member

Local time

Today, 10:18

Joined

Oct 29, 2018

Messages

21,454

• Nov 21, 2019

• #2

Hi. Your question is a little bit confusing. First you asked how to convert a combobox to a listbox, but in the end you asked how to convert it to a textbox. In any case, have you tried right clicking on it and then select Change To?

 

C

Casperaprel

New member

Local time

Tomorrow, 00:18

Joined

Nov 21, 2019

Messages

8

• Nov 21, 2019

• #3

k i tried right-click to change to the text box but the list i wanted didn't come out like using combo box

I want to be in that picture .. from the combo box I want to turn it into a text box formula.

sorry if my question is confusing

 

C

Casperaprel

New member

Local time

Tomorrow, 00:18

Joined

Nov 21, 2019

Messages

8

• Nov 21, 2019

• #4

hi theDBguy, can u help me ... thanks for respone... acctually this my firstime post from forum... soryy ; )

 

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 03:18

Joined

Jan 20, 2009

Messages

12,851

• Nov 21, 2019

• #5

Textboxes don't have a RowSource.

You need to provide a detailed description of what you are trying to achieve in terms of functionality. Forget about what kind of control you want to use.

 

C

Casperaprel

New member

Local time

Tomorrow, 00:18

Joined

Nov 21, 2019

Messages

8

• Nov 21, 2019

• #6

hye Galaxiom..ok if combo box we can source through row what we want ... so i want to use the same concept as combox box but it doesn't work. for the example what i want like my attachment picture...

 

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 03:18

Joined

Jan 20, 2009

Messages

12,851

• Nov 21, 2019

• #7

A textbox can refer to a column of a combobox in its ControlSource. This expression will get the second column of the combos RowSource. (The columns are numbered from zero.)

Code:Copy to clipboard

 = comboname.Column(1)

https://docs.microsoft.com/en-us/office/vba/api/access.combobox.column

 

C

Casperaprel

New member

Local time

Tomorrow, 00:18

Joined

Nov 21, 2019

Messages

8

• Nov 21, 2019

• #8

I tried but didn't work: example ---->

=([TAJUKCOMBO];[tblProgram.TajukProjek](1))

 

C

Casperaprel

New member

Local time

Tomorrow, 00:18

Joined

Nov 21, 2019

Messages

8

• Nov 21, 2019

• #9

my combo title "TAJUKCOMBO'' my sql detail ------>

SELECT tblProgram.ID, tblProgram.TajukProjek
FROM tblProgram;

how to convert to textbox ..

 

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 03:18

Joined

Jan 20, 2009

Messages

12,851

• Nov 21, 2019

• #10

Literally the word "Column" not the name of the field in the RowSource.

And a dot rather than a semicolon. It is the Column Property of the combo.