Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
Dim queryAll as String Dim appRS as object Dim NodeX as Node queryAll = "SELECT * FROM Appointment WHERE appDate = CURDATE() ORDER BY Staff/Resource, appontmentType, startTime" Set appRS = gDBUtility.getRSA(queryAll)'This populates RS. If Not appRS Is Nothing Then While Not appRS.EOF 'I understand all the Add Nodes syntax 'Child Set NodeX = TreeView1.Nodes.Add(,,aappRS!Staff,appRS!Staff) ' However above will create the same node every time and Crash. 'Child Set NodeX = tv1.Nodes.Add(appRS!Staff,tvwChild,appRS!uniqueKey,appRS!appointmentType) appRS.MoveNext Wend appRS.Close Set appRS = Nothing End If