[AccessD] A2K: Basic Design Question

You're specifying these options for each record in the continuous form?  If
that's the case, why not just base the form on a multi-table query? I
probably don't understand the question. :)

Susan H.


> 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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>