Hi,

I find myself once again returning to a problem project I have been so far
unable to finish...

I have a table of teaching session data and another of teachers, with a link
between the two. I have an unbound form with 20 labels (4 x 5 arrangement
for each teaching session in a week) that when clicked open a data entry
form for the specific session clicked on (eg monday, 9:30 am).This part
works fine.

What I would like is for the labels for each session to be updated with a
text string summarising each session once a week has been selected from a
combo box. I vaguely know what I need to do but require some help in the
specifics.

I know I could do this using 20 different record sets, eg:

OpenRecordSet("Select * FROM [SessionTable] WHERE [SessionTable].[Date] = "
& DateFromComboBox " & " AND [SessionTable].[StartTime] = " & StartTime &
";")

but would this create a significant delay accessing data accross a network?
Could I instead create one record set for the whole week (possibly using a
temporary table) and then search within that?

Any comments would be greatly apprectiated,

Dickie Black