subform Problem access 2002

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have a form (frmMeasure) with a sub form (frmMemo).
The sub form is built on a table that has only 3 fields:

Its own Recnum (autonumber)
a recnum corresponding to the measure recnum and
a memo field.

The record source of the sub form consists of those 3 fields with the
criteria of the measure recnum being = to the value of the recnum field on
the main form.

The problem that I have is that whenever I go to a new record on the main
form, it automatically adds a corresponding record in the memo table. I
would like for the record only to be added if I actually have a memo.

How can I do this?
 
sounds like a simple form/subform setup that should work
exactly the way you want it to. i wrote up two quick
scenarios in Access 2000, one with a parent/child one-to-
many relationship, the other with a parent/child one-to-
one relationship w/ a shared primary key. either way, the
form/subform data entry worked the way it should.
i'm emailing both dbs to you, so you can compare working
setups to your own and possibly spot your problem.
hope it helps.
 
Back
Top