Duane
Thanks for the reply.
I am currently only experimenting with my database at the moment until I get
it working correctly.
Table one has just two fields, the date and a record number (E.g: 123456AA,
234567AB, 345678AB, 456789AA....). Table one will hold all the master record
numbers.
Table two also has two fields, the date and a record number. Table two's
record numbers will only be ones that appears in table one (E.g: 345678AB).
My form and subform look okay but as I step through table ones records,
table ones record number keeps appearing in the subform although the record
number may not appear in table two. When a genuine record number match is
found in table two, the record number appears again as described above and
then the date and record number from table two because of the match. I would
like just the date and record number from table two to appear in the subform.
I know this is probably a very simple fix but I cannot work out what is
wrong. I can send you a copy of the database if required or a screen print if
this will help.
Thanks
Johno