Clone Reocrdset to query based on combo

[mo2783]

Hi

I have a combo box on a form which has values when a user selects a value i am running a SQL statement which brings the data.

I was wondering whether i could clone that recordset so the form is populate with the cloned data?

i have the following code

    Dim rsFoundSerachDescription As DAO.Recordset
    
    Dim strSQl As String
    
    strSQl = "SELECT ECRDatabase.*, ECRDatabase.ED_PartDescription " & _
    "FROM ECRDatabase " & _
    "WHERE (((ECRDatabase.ED_PartDescription)=" & Chr(34) & Combo484 & Chr(34) & ")); "

    Set rsFoundSerachDescription = PartDescriptionSerach(strSQl)

I would appreciate any help, to achieve this?

thanks

Mo

 

[Remou]

I am not quite sure what you wish to achieve. Can you not set the RecordSource of the form to strSQl?

strSQl = "SELECT ECRDatabase.*, ECRDatabase.ED_PartDescription " & _
    "FROM ECRDatabase " & _
    "WHERE ECRDatabase.ED_PartDescription)=" & Chr(34) & Combo484 & Chr(34)

Me.RecordSource=strSQ1

 

[TheAceMan1]

How are ya mo2783 . . .

Why bother with cloning. Just set the recordsource to the sql:

[blue] Me.RecordSource = strSQL[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[mo2783]

Remou/TheAceMan

Thanks for the solution, exactly what i was looking for.

Mo