Hi All, im currrently working on a cover system for a school. To book the cover in i am using a form which shows the day (period's 1-5) as labels with tick boxes below them. i want to make the labels change it the actual subject that period. so what i do is select a day from DayCB (combo box) which has monday to friday in it as strings, then i choose a teachers code and then the labels should change. this is where i am stuck asa i need to reference the subject in question from my access database. i used the wizard to set up my connection which i know works. all i need is the command which is used to reference a specific collumn and row.
tanks in advance
James.