I wish to add a 7 day calendar to the switch board form, but I'd like to 
populate each of the day boxes with fields from a query. In essence the query 
locates things to do in the week. For ease of the user i'd like them to be 
able to see a 7 day calendar with the fields "ownerid","make","model" based 
upon the value in "next_due" (eg "next_due" is during that week)
Thank you

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20Demo.mdb'

for some examples. You would need to write a bit of VB code.

Peter Hibbs.

On Wed, 7 Nov 2007 00:57:01 -0800, Accessidiot
<Accessidiot@discussions.microsoft.com> wrote:

>I wish to add a 7 day calendar to the switch board form, but I'd like to 
>populate each of the day boxes with fields from a query. In essence the query 
>locates things to do in the week. For ease of the user i'd like them to be 
>able to see a 7 day calendar with the fields "ownerid","make","model" based 
>upon the value in "next_due" (eg "next_due" is during that week)
>Thank you