Synchronized Combo boxes - display list ?

[FergusonH]

Hello,
On 8/4/05 I submitted a question on combo boxes which David Cleave answered
(and really helped me out : ) )

I have a follow up now, when I added the VBA code to the "afterupdate" for
my first combo box, the second combo box is now correctly limited to only
those values with matching id's from the first combo box selection, but they
aren't visible in the list- you can select a blank and then it inputs the
real value as soon as you go to the next field, but you can't see the items
in the list. I checked the properties but I don't see anything odd, I have
Visible = YES and Display= ALWAYS. ??

Here's the code I added to the first combo box in the events "After Update"
box:

Private Sub Process_AfterUpdate()
[Productivity Code].RowSource = "Select [t_productivity].[Productivity Code]
FROM [t_Productivity] WHERE [t_Productivity].[process id] = " & [Process]
End Sub

Please help me if you can : ) This is weird!

 

[Ofer]

What are the properties of the second combo?
For example the ColumnWidths Property, if it set to something like 0;2 which
mean that the first field wouldn't display, and because there is only one
field in the select SQL, you want see any values.
In that case change it to 1 number ,3 cm for example, and not 0.

 

[FergusonH]

Thanks! I actually modified the vba code to select both fields and that
worked perfectly!!! thank you!

What are the properties of the second combo?
For example the ColumnWidths Property, if it set to something like 0;2 which
mean that the first field wouldn't display, and because there is only one
field in the select SQL, you want see any values.
In that case change it to 1 number ,3 cm for example, and not 0.
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Hello,
On 8/4/05 I submitted a question on combo boxes which David Cleave answered
(and really helped me out : ) )

I have a follow up now, when I added the VBA code to the "afterupdate" for
my first combo box, the second combo box is now correctly limited to only
those values with matching id's from the first combo box selection, but they
aren't visible in the list- you can select a blank and then it inputs the
real value as soon as you go to the next field, but you can't see the items
in the list. I checked the properties but I don't see anything odd, I have
Visible = YES and Display= ALWAYS. ??

Here's the code I added to the first combo box in the events "After Update"
box:

Private Sub Process_AfterUpdate()
[Productivity Code].RowSource = "Select [t_productivity].[Productivity Code]
FROM [t_Productivity] WHERE [t_Productivity].[process id] = " & [Process]
End Sub

Please help me if you can : ) This is weird!