Use value from listbox to go to record 1

[Niebotel]

I have a form with a listbox on it. The Listbox contains 3 fields. I want to use the second field for directly jumping the form to the record which contains this value. I cannot get it running;
Please help; the wizard which actually should arrange this in standard Access is not available (i do not know why)

 

[PHV]

Have a look at the Column property of your ListBox

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Niebotel]

Please give some more info; Im struggeling already for hours!

 

[PHV]

Im struggeling already for hours
What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Niebotel]

I tried:
With Forms!facturenArchief.RecordsetClone
.FindFirst "ID = " & Me.ZoekZoek.Column(4)
End With

Tells me types mismatch
If I debug the value Me.ZoekZoek.column(4) contains the right value but ...

I tried simular code with Docmd.gotorecord

 

[PHV]

If ID isn't numeric:

.FindFirst "ID=[!]'[/!]" & Me!ZoekZoek.Column(4) [!]& "'"[/!]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Niebotel]

.FindFirst "ID = " & Me.ZoekZoek.Column(4)
Gives arror: 3077 Syntax error : operator missing

.FindFirst "ID='" & Me!ZoekZoek.Column(4) & "'"
Gives error 3464: Type mismatch

Hope you want to help me once again

 

[PHV]

If I debug the value Me.ZoekZoek.column(4) contains the right value
Which value ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Niebotel]

It contains the value of the the field ID in the listbox.
I have 4 fields in the listbox; the 4th is the field ID.

I want to jump to the record with that ID.
ID is the primery key

 

[PHV]

the [!]4[/!]th is the field ID
.FindFirst "ID = " & Me.ZoekZoek.Column([!]3[/!])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Niebotel]

Thanks a lot!!