I'm having difficulties in my forms/subforms in which i think it has to do
with my two tables that I have created. I'm currently working on a project
in which the database will print out a certificate of completion. One table
contains only the dates (or should say days) in which the course has
occurred. One date per meeting. The second table contains the names of the
attendees, birthdates, and the date that they have attended (supposedly the
user can pick it out from a drop box from the values in the first table). In
anothers, one session date can have may attendees. However, I get an error
saying lookup wizard cannot be used with date/time.

My GOAL: Have a form in which the user would have to enter a new date (in
which the user wants to work on) and start adding the names of the attendees,
and birthdate (subform) without entering the same date for each record. Is
there any way to do this? In addition, is it possible to blend the subform
into the main form. The transparent doesn't work and I have a watermark
background in my main form.

Any help is appreciated. Last time that I played with Access was Access 95
several years ago and never used Access since.

On Wed, 20 Dec 2006 18:58:00 -0800, Lady Nightshade
<(E-Mail Removed)> wrote:

>My GOAL: Have a form in which the user would have to enter a new date (in
>which the user wants to work on) and start adding the names of the attendees,
>and birthdate (subform) without entering the same date for each record. Is
>there any way to do this? In addition, is it possible to blend the subform
>into the main form. The transparent doesn't work and I have a watermark
>background in my main form.

The Lookup Wizard isn't the best (or even a good!) way to do this.

You can use a Form with a textbox or a combo box for the date; it can
be in the form's Header or just on the main portion of the form. The
Subform's Master Link Field would be either the name of the datefield
in the dates table, or simply the name of the control in which that
date is entered; the child link field would be the date/time field in
the attendance subform's table.

I'm not sure just what you want with the "blend". What other controls
are on the mainform, and what does it mean that "the transparent
doesn't work"???

John W. Vinson[MVP]