Keeping Sub Form consitant with Datasheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sera - 30 Nov 2006 03:35 GMT

I have a form with a sub form set up.
My form has information on an individual
My sub form has information about each time that individual i
searched.

The only field that the two forms have in common is the VisitorID

I had to select "Indexed (Duplicates OK)" inorder to enter multipl
searches for one individual. When I enter in the information in th
table view, everything works fine.

When I try to enter the information in on the Form view I have
problem. I cannot get the search information to go with the righ
individual.

Example
John Doe was searched once
Jane Doe was searched once
Mike Smith was searched twice
Jane Smith was searched once

It wants to enter the second search of Mike Smith to John Doe.

Any ideas on how to keep this consistent? What am I missing?

TI

--
Ser

Posted from - http://www.officehelp.i

Reply to this Message

John Vinson - 30 Nov 2006 06:26 GMT

>I have a form with a sub form set up.
>My form has information on an individual
>My sub form has information about each time that individual is
>searched.

The first thing to realize is that the Form doesn't contain ANYTHING.

The data is stored in your Tables; the form is only a window, a tool
to edit data in the tables.

>The only field that the two forms have in common is the VisitorID
>
>I had to select "Indexed (Duplicates OK)" inorder to enter multiple
>searches for one individual. When I enter in the information in the
>table view, everything works fine.

How, if at all, are your tables related? What is the Datatype of
VisitorID in each table?

>When I try to enter the information in on the Form view I have a
>problem. I cannot get the search information to go with the right
>individual.

What's the Recordsource of your form and of your subform? And what's
the Master and Child Link Field?

>Example
>John Doe was searched once
[quoted text clipped - 3 lines]
>
>It wants to enter the second search of Mike Smith to John Doe.

Guessing in the dark here... but are you perhaps using Autonumber as
the datatype of VisitorID in the search table? If so... that won't
work!

John W. Vinson[MVP]

Reply to this Message