Access form question

[Imhotep9]

Newbie Access question --

I am trying to build a form that can assign the contents of one field to ALL records that are created by subsequent fields.

For example, the form would have a date field and then multiple fields for bird observations, like this:

DATE: October 15, 2010
BIRD OBSERVATION #1: Sparrow
BIRD OBSERVATION #2: Sparrow
BIRD OBSERVATION #3: Robin
BIRD OBSERVATION #4: Sparrow
BIRD OBSERVATION #5: Robin

The point is to keep from entering the date five times. So you enter date once then log all the bird observations and the result would be 5 new records added to the table with the contents of the DATE field being assigned to all of them while the other fields are unique.

Is there a way to do this?

 

[SkipVought]

Hi,

Please post MS Access questions in one of the MANY MS Access forums like forum703.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

If you were to post this to forum702 you might get a suggestion to put the date on the main form and use a subform for your records entry. The use of Link Master/Child will keep the dates in synch.


Duane
Hook'D on Access
MS Access MVP