I can't select value from a combobox why? (1 Viewer)

[bmkol]

I have a form (Hebrew) with few comboboxes all of them working good except one that not letting me selecting a value and I can't understand the problem
Here are 2 screen shuts the first one is where I want to select and the second one is after I selected

1.

2.

It give me just the first one all the time

Please help

 

[MajP]

What is the control source? Is the field locked?

 

[bmkol]

What is the control source? Is the field locked?

It doesn't have a control source becuase it based on vba code

 

[theDBguy]

Sounds like the bound column may have duplicate values. Does it?

 

[bastanu]

If the combo's are used to filter or search records on the form they should be unbound otherwise you will be editing the (first) record with every change.
EDIT: too late, I see you have them unbound. Would you please show us the VBA code that sets the row source?

Cheers,

 

[bmkol]

Sounds like the bound column may have duplicate values. Does it?

Only 1

 

[theDBguy]

Only 1
View attachment 96845

Sorry, that's not what I meant. For example, typically, a combobox would display one column but actually have a hidden one, which is the bound column. If so, I was saying perhaps that hidden column contains duplicate values, like this:

1, Item1
1, Item2
1, Item3
etc...

 

[oleronesoftwares]

It give me just the first one all the time

Do you mean, it selects the first row on the combo box all the time?

 

[bmkol]

Do you mean, it selects the first row on the combo box all the time?

Yes

 

[oleronesoftwares]

It doesn't have a control source becuase it based on vba code

Can we see the vba code that is the underlying code?

 

[bmkol]

Sorry, that's not what I meant. For example, typically, a combobox would display one column but actually have a hidden one, which is the bound column. If so, I was saying perhaps that hidden column contains duplicate values, like this:

1, Item1
1, Item2
1, Item3
etc...

It has one hidden column (the id) ... here is the vba code:

strSqlPerek = "SELECT tblPasuk.ParashaId, tblPasuk.PasukNum FROM tblPasuk WHERE (tblPasuk.ParashaId=" & Form_frmPsukim.cmbParasha.Value & ") AND " & " (tblPasuk.PerekNum='" & Form_frmPsukim.cmbPerek & "') "
Me.cmbPasuk.RowSource = strSqlPerek
Me.cmbPasuk.Requery
Me.cmbPasuk = Me.cmbPasuk.ItemData(0)

 

[bmkol]

Can we see the vba code that is the underlying code?

here it is:

strSqlPerek = "SELECT tblPasuk.ParashaId, tblPasuk.PasukNum FROM tblPasuk WHERE (tblPasuk.ParashaId=" & Form_frmPsukim.cmbParasha.Value & ") AND " & " (tblPasuk.PerekNum='" & Form_frmPsukim.cmbPerek & "') "
Me.cmbPasuk.RowSource = strSqlPerek
Me.cmbPasuk.Requery
Me.cmbPasuk = Me.cmbPasuk.ItemData(0)

 

[bastanu]

So it looks like theDBGuy was right, you are selecting only one ID for your bound (hidden) column: =" & Form_frmPsukim.cmbParasha.Value
And you don't need the requery after you set the row source. And why select the first entry?

 

[bmkol]

So it looks like theDBGuy was right, you are selecting only one ID for your bound (hidden) column: =" & Form_frmPsukim.cmbParasha.Value
And you don't need the requery after you set the row source. And why select the first entry?

But I do have 2 columns as in the picture when the first one is hidden

 

[bmkol]

O.K ... I found the problem ... from what

bastanu asked ... I changed the bound to 2 and it is ok now.​

Thanks to evryone that tried to help

 

[theDBguy]

O.K ... I found the problem ... from what

bastanu asked ... I changed the bound to 2 and it is ok now.​

View attachment 96847


Thanks to evryone that tried to help

Glad to hear you got it sorted out. Good luck with your project.

 

[bmkol]

Glad to hear you got it sorted out. Good luck with your project.

theDBguy I want to thank you too your answer is exactly the problem I had, but I was stupid not to understand it. ​

 

[theDBguy]

theDBguy I want to thank you too your answer is exactly the problem I had, but I was stupid not to understand it. ​

No worries. The main thing is that you were able to fix it. Cheers!

 

[Pat Hartman]

You are using the combo itself as criteria for its RowSource. That doesn't sound right.

PS - you can just put the query into the RowSource. You don't need code to load it.