Populating a Datalist control

[Rechmali]

Hi,

I was wondering if anyone knows how to programmatically populate a datalist.

I am able to bind it, but have a feeling I read somewhere about doing it in the program so that I can play around with the data first.

I have in mind an AddNew property, but can't seem to work out how to do it.

Below is code using a bound record source.

I would really appreciate any input,

Many thanks,

Chris

With dblDiagnosis
    
    Set .RowSource = rs
        .ListField = "Diagnosis"
        .BoundColumn = "DiagID"
        
End With