Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Cannot get Embedded Form to Allow Data Entry

Posted on 2006-04-25
Medium Priority
Last Modified: 2010-08-05
I have a data entry form, which has another form embedded into it.  When I open the data entry form, I cannot get the embedded form to accept data entry.  I have done this before, and have compared a form in an earlier database with my new database forms.  I cannot find the setting that I must change in order to get it working as I want.  And now, I'm tired of spending too much time trying to figure it out!!  Can someone help me?
Question by:PHS_IT
LVL 46

Expert Comment

ID: 16534163
Make sure you've got AllowAditions & AllowEdits set to True
Good Luck!

LVL 66

Accepted Solution

Jim Horn earned 2000 total points
ID: 16534192
(Wild guesses)
Make sure that subform (embedded form) has a recordsource that is updatable.  If it uses a query that has multiple tables, or if it queries the same table(s) as your main form, this may not be the case.

Author Comment

ID: 16534194
Yes, both of those are already set to Yes.
LVL 44

Expert Comment

ID: 16534232
The settings should be on the SUB-form (AllowEdits = True, and AllowAdditions = True)  Just wanted to make sure that you had those set on the Sub-form (it was not clear from either the suggestion or your response, that the settings were for the Sub-form, itrself)

LVL 66

Expert Comment

by:Jim Horn
ID: 16534300
PHS_IT, thanks for the grade.  Can you tell us what exactly solved the problem?

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question