By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

How do I prohibit new records in subform?

P: 1
I have a main form w/ two subforms in Access. Based on their parent/child fields, the subforms call up existing matching records. My problem is: when there is no matching record in my subform it automatically creates a new record and populates it with whatever is entered in the parent field on the main form. I would like the user to be able to add and edit records on the main form regarless if there is a match on the subform or not. When there is a matching child record in the subform, I would like the user to be able to edit those fields.

I don't think I can use referential integrity to control this because my main form has many (duplicate) records and this is the 'parent' field in the link (i.e. a one-to-many relationship).

Any tips?

- mgoodman
Mar 17 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,653
Hi, mgoodman.

Actually, I could hardly imagine SubForm control creating new record automatically. Do you have any code behind?

Mar 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.