I can't select value from a combobox why?

B

bmkol

Member
Local time
Today, 10:13
Joined
Dec 2, 2021
Messages
39
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.
1639518122792.png


2.
1639518196918.png


It give me just the first one all the time

Please help
 
What is the control source? Is the field locked?
 
MajP said:
What is the control source? Is the field locked?
Click to expand...
It doesn't have a control source becuase it based on vba code

1639518711340.png
 
Sounds like the bound column may have duplicate values. Does it?
 
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 said:
Only 1
View attachment 96845
Click to expand...
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...
 
theDBguy said:
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...
Click to expand...
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)
 
oleronesoftwares said:
Can we see the vba code that is the underlying code?
Click to expand...
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)
 
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?
 
bastanu said:
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?
Click to expand...
But I do have 2 columns as in the picture when the first one is hidden

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

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

1639520461462.png



Thanks to evryone that tried to help
 
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.
 
You must log in or register to reply here.

Similar threads

AOB
Solved Detect whether a combobox selection has actually changed or just reselected?
Replies
18
Views
1,242
jwcolby54
jwcolby54
M
When I select a value from the Section field, it should automatically combine with the corresponding values.
2
Replies
33
Views
1,714
MadPiet
M
Libre
40K crashing Long Integer data type
Replies
8
Views
753
Libre
Libre
B
Pop up forms not "stacking" in the right order
Replies
12
Views
901
CJ_London
C
K
Solved Combobox in Subform not updating data
Replies
2
Views
437
kiaconchim
K

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom