Filter or FindRecord in Split Form

[P5C768]

I'm trying to use a unbound combobox with a ID and Name field (only displaying name) on a split form that will apply a filter or use findrecord in the afterupdate event of the combobox to go to the record in the split form selected by the combo box. Findrecord wasn't working, so I tried filter using this code:

Private Sub Combo11_AfterUpdate()
    Me.Filter = "Supervisor_ID=" & Me.Combo11 & ""
    Me.FilterOn = True
End Sub

But it prompts for the supervisor ID, even though the code shows that the value passed should be correct. If I manually enter the ID in the prompt, the filter applies as how I was expecting the code would work. Any insight? Thanks!

[June7]

Is the ID column the BoundColumn? Is the supervisor ID a text or number datatype?

If number:
Me.Filter = "Supervisor_ID=" & Me.Combo11

If text:
Me.Filter = "Supervisor_ID='" & Me.Combo11 & "'"

Just to keep in mind, if value is a date:
Me.Filter = "datefield=#" & Me.Combo11 & "#"

[P5C768]

Yes, the ID is the bound column and yes, the field is text (alphanumeric data). When I changed the coding to what you have above (added apostrophes), it looks like it is referencing the item number of the combo box rather than the value. I tried adding .value with no avail.

[P5C768]

Sorry, I just realized the bound column was wrond after all. I always forget the first column is 0, not 1. Working perfectly now. One further question, I wanted to use a field containing employee name on the split form to allow users to click on the name and move to another form. I'm trying to learn more about embedded macros so i tried usijng that method, but I can't get the macro to activate the record clicked on, it just goes to the first record. Any thoughts? I tried using the same coding that I used to filter the split form.

Employee_frm, Form, , "Supervisor_ID='" & [Forms]![Supervisor_frm]![Employee_ID] & "'", , Dialog

[June7]

It works? BoundColumn property numbering starts with 1, not 0. Column index reference starts with 0. Not understanding what you mean by 'item number of the combobox'.

Don't know. I don't use macros. I would have to analyse the project if you want to provide it.