[AccessD] A2K: Basic Design Question

Hi Stuart
(I'm getting your posts twice)
I tried the subform thing before with no joy.
On my version of Acccess2K If I set a form to be continuous then
enable/add the relevant header and footers. Each time a try to add a subform
I get the message box....
<bold> A form with a subform object can't have it's DefaultView set to 'continuous forms'
You tried to add a subform to a form in desgin view
Microsoft Access will reset the property to Single form

Then the monster turns the Parent form from continuous to single. Bugger

Any other suggestions really appreciated

Darren

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Darren DICK" <d.dick at uws.edu.au>; <accessd at databaseadvisors.com>
Sent: Tuesday, May 27, 2003 11:27 AM
Subject: Re: [AccessD] A2K: Basic Design Question


> On 27 May 2003 at 10:03, Darren DICK wrote:
> 
> > Hi Susan
> > Thanks for the reply
> > tblReminders has hundreds of records in it with about 7 or 8 fields.
> > tblOptions will only ever have 1 record in it with about 5 or 6
> > fields.
> > 
> > Nothing in tblOptions relates to anything in tbleReminders.
> > tblReminders has date, time, YesNo flags and text fields that hold
> > info about appointments.
> > 
> > tblOptions has similar fields but hold local settings info eg how long
> > a timer interval is the path for various logos, paths for sound files
> > etc. There will only ever be one record in this table
> > 
> 
> Create a subform based on tblOptions and put that in the footer of 
> the form based on tblReminders
> 
> .
> 
> 
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System 
> Support.
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com