Jump to a record based on a combobox

[ppataki]

Dear All,

I have a simple form bound to a table
I have a combobox on it and I would like the form to display the record that contains the value of the field I select in the combobox

I tried the following but it does not work, nothing happens:

Private Sub CustNameCombo_Click()
DoCmd.FindRecord Me.CustNameCombo
End Sub

Could you please advise?
Many thanks

 

[MStef]

Look at "DemofindA2000.mdb" (attachment, zip).
Open form and try.
Look at VBA.

 

[ppataki]

Hello,

I have tried it like this:

Private Sub CustCombo_AfterUpdate()
Me.RecordsetClone.FindFirst "[CustName] = " & Chr(34) & Me.CustCombo & Chr(34)
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

and still nothing happens
Any suggestions please?
Many thanks

 

[MStef]

Write it as it is in my Demo.

 

[ppataki]

I did it:

Private Sub CustCombo_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Custname] = '" & Me![CustCombo] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

still nothing...
What do I do incorrectly?

Thank you very much

 

[MStef]

Is the "Custname" field TEXT or NUMBER ??

 

[ppataki]

It is Text

 

[MStef]

Send a short example of DB. Access 2000 or 2002.

 

[ppataki]

This is a new Access X-files!

I have just deleted the combobox, created a new one and now it works!!!
Thank you very much for your help!!!!