Unable to delete/add members in a subform

A

Amit

MS Access 2K, Windows XP
====================
Hi,

I have a form (frmProgram) with a subform (sfrmCommittee) in it that lists
the Committees for a Program. The sfrmCommittee has Allow Edits, Allow
Additions, Allow Deletions set to No.

I have a form frmCommittee that allows a user to add a new committee. This
form has a subform sfrmCommitteeMember to add new committee members for this
committee.

The form frmCommittee can be opened in two ways.

1. Clicking a button "Add New Committee" on frmProgram that opens
frmCommittee.

2. Double-clicking the committee name in sfrmCommittee opens frmCommittee
with information related to the committee that was clicked.
The code for 2. is:
stDocName = "frmCommittee"
stWhere = "[CommitteeID] = " & Me![CommitteeID]
DoCmd.OpenForm stDocName, , , stWhere, acFormEdit

This is all working fine, except that I'm unable to add/delete committee
members when I open frmCommittee using 2. I've checked the Properties for
frmCommittee and sfrmCommitteeMember and they both have their Allow
Additions, Allow Edits and Allow Deletions set to "Yes". The Record Lock is
"No Lock" and Recordset Type is "Dynaset".

I'd like to be able to add/delete members when I open frmCommittee by
double-clicking on the committee name (2.). I'm unable to figure out how to
do this.

I'm guessing that since sfrmCommittee has the Allow Edits, Allow Deletions
and Allow Additions set to "No", somehow, these properties are being carried
over to frmCommittee and sfrmCommitteeMember when frmCommittee is opened
through sfrmCommittee.

I'll try and set these properties explicitly, but if someone knows what is
going on here, and can point me in the right direction, will appreciate it.

Thanks!

-Amit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top