>Select course.coursenumb, course.coursename, ; > table2.g1, table2.g2, table2.wm1, table2.g3, table2.tot1, ; > table2.g4, table2.g5, table2.wm2, table2.g6, table2.tot2, table2.ltot ; > from Course ; > inner join TABLE2 on table2.no = course.no ; > into cursor csrCourseStats readwrite > >Thisform.Grid1.RecordSource = "csrCourseStats" >>
With Thisform.Grid1. .RecordSource = "csrCourseStats" With .Column1 .Width = 200 .Header1.Caption = "Anything you like" .Font = "arial" .FontSize = 12 ... EndWith With .Column2 .Width = 45 .Header1.Caption = "yellow bird" EndWith ... EndWithYou set any of the properties that appear on the property sheet for each container