Open form from a listbox

[raphael99]

I use:

DoCmd.OpenForm "My second form", , , "Customers = '" & Me.listbox name & "'"

for open a second form from a list box . It is working but when I open the second form it opens the first record of same customer name.
In example:
Marion Bette
Marion Dave


Marion Junior
When I click on on Marion Bette it opens the right record: Marion Bette
When I click on Dave or Junior it still opens Marion Bette record.
Can anyone please help?
Thanks

[Bob Fitz]

I think that your problem may be with:
Me.listbox name
Perhaps you need to refer to the combo box column that will match with the field "Customers". Maybe something like
Me ComboxName(1)
Is "Customers" a Primary Key field.
What is the SQL Row Source of the combo box

[raphael99]

Row source is a query.
Me.listboxname(1) does not works.
I 'm not sure what you mean for primary key field (I have an ID but that is not included in the query)

Thanks for your reply

[Bob Fitz]

Please show the SQL statement of the query

[raphael99]

SELECT tblAnagrafica.Cognome, tblAnagrafica.Nome, tblAnagrafica.Indirizzo, tblAnagrafica.Comune, tblAnagrafica.[Tessera Sanitaria], tblAnagrafica.[Codice Fiscale], tblAnagrafica.ID
FROM tblAnagrafica
WHERE (((tblAnagrafica.Cognome) Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*")) OR (((tblAnagrafica.Nome) Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*")) OR (((tblAnagrafica.Indirizzo) Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*")) OR (((tblAnagrafica.Comune) Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*")) OR (((tblAnagrafica.[Tessera Sanitaria]) Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*")) OR (((tblAnagrafica.[Codice Fiscale]) Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*"));

[Bob Fitz]

So which column in tblAnagrafica will be = to Customers

[raphael99]

Customers = Cognome

Anyway i solved asking around and the solution (the working one) is :

DoCmd.OpenForm "My second form", , , "ID = " & Me.listbox name.Column(6)

where (6) is the ID column number in the listbox
Hope this help some others

Thank to you.