[AccessD] A2K: Basic Design Question

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




More information about the AccessD mailing list