John Colby
jcolby at colbyconsulting.com
Mon May 26 18:41:25 CDT 2003
How much info in this option table? Can it go in a combo or list control? John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK Sent: Monday, May 26, 2003 7:27 PM To: AccessD List Subject: [AccessD] A2K: Basic Design Question 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