Darren DICK
d.dick at uws.edu.au
Mon May 26 18:27:18 CDT 2003
Hello all I have a continuous form that has varying recordsets. Pretty much the same data but with things like... Show for a Date or a Date Range Show for Completed/ Not Completed Show for Future/Past/Next week etc etc. All held in tblReminders I have a set of options all held in tblOptions. I want the settings kept in the options table to be presented to the user in the footer of the continuous form. But I can't get the 2 together because they have no matching record. I can't put the options in a sub form because you can't have a sub form in a continuous form. I though about a union query but that means I would have to manage all the current RecordSet setting in pure SQL - I'm not good enough for that. Anyway how do you guys handle these situations? Many thanks in advance Darren