Access VBA Combo Box

I am trying to duplicate a box used on an old database within a new one and I have set all the parameters to be the same, size etc, but when I try to use the combo box on the form in form view I get the following message:

The record source '~sq_cfrm:PartOne~sq_cCombo46' specified on this form or report does not exist

You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database.

In the Form or Report's Design view, display the property sheet by clicking the Properties button, and then set the RecordSource property to an existing table or query.


When I check this it gives me the correct link to the frm:Searches and when I Debug it has the following code:

Sub Combo46_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[NYCCID] = " & Me![Combo46]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Maybe I am just being stupid but nowhere in my old database was there a recordset called Clone and I cannot work out why it would think there is. Is the use of Clone as a recordset something that I should remember from my training?

Thanks

Nikki

RE: Access VBA Combo Box

Stephen,

I will have a look at trying that tomorrow, but have put it down for today in case I punch my screen!

Thanks Very Much

Nikki