Keeping Sub Form consitant with Datasheet

S

Sera

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
 
J

John Vinson

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.
Click to expand...

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.
Click to expand...

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.
Click to expand...

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
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.
Click to expand...

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]
 
Top