Open second Form Limited to records related to current Record (one to many) and add a record to the many side.

[joe-tec...@joeschmittjr.com]

Hi,

I have a form that lists proposals using "ProposalID" from the
Proposals Table.
The Upper part of form (Header area) shows info about one record. The
body of the form is set to continuous forms. You can click on a record
in the body and see the details in the header.

I have a ProposalNotes Table Which can have multiple records
associated with a single Proposal ID. The notes table has these
fields:
NoteID (Autonumber key)
ProposalID
Note
Date Entered

There is a button in the header of the main form that opens a form
based on the Proposal notes table. I can have the Notes form open and
show only notes associated with the record in the header of the main
form.

The problem I'm having is that I can't add a new note because the
records in the notes form are associated to the proposal ID.

Here is the code for the button that opens the Notes form:
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_ProposalNotesSubForm"
stLinkCriteria = "[ProposalNotes.ProposalID]=" & Me![ProposalID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Here is the error message I get when I try to add a new note with the
Notes form:
"You can not add or change a record because a related record is
required in table Proposals"

Any suggestions are welcome,
Joe