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

Adding a subform to a Data Entry main form... subform greyed out

P: 4
I have a main form ApplicationSubmission with the data entry property set. I'm trying to add a subform to it, that allows the user to select from a list of standard documentation the user anticipates will be required, associated with the Application they are submitting. In all my attempts, the subform is completely greyed out, including all navigation buttons. I have 2 tables, Applications and ApplicationDocs. Applications has a Autonum as PK, while ApplicationDocs has an ApplicationID and DocID, neither of which are PKs. A third table drives the Row Source for a combo box on the subform. This third table has DocID as a PK. What am I missing? At the time the main form loads, ApplicationID is '(New)', so I would expect the subform not to have an ApplicationID. I tried some event-driven refreshes of the subform to no avail. Please help.
Apr 5 '16 #1

✓ answered by mule1350

The subform will always be empty, because the main form is a Data Entry form.

I finally figured it out... Even though both the main form and subform are set to Data Entry = Yes, I still had to set the Allow Edits to Yes on the main form. My main form is in Single Form vies, it does not contain record selectors, and it suppresses the mouse scroll from cycling records, anyway. So, the user is still prevented from editing other records, even though I've now set Allow Edits... which is exactly what I want.

Thanks so much for your time and effort!

Share this Question
Share on Google+
5 Replies


Expert 100+
P: 1,221
What is the link between the main form and the subform. I suspect there is no record found in the subform's dataset to match the link to the main form. In design mode, click on the subform container, the look at the linkage in the data tab of the properties box.

Jim
Apr 5 '16 #2

P: 4
Link master fields is set to the Application ID on the main form. Link child fields is set to the Application ID on the subform. The ApplicationDocs table is empty, even after the ApplicationID is showing on the main form.
Apr 5 '16 #3

P: 4
Currently, the record source for the main form is the Applications table, while the record source for the subform is the ApplicationDocs table. Does either record source need to be a query of both tables instead?
Apr 5 '16 #4

Expert 100+
P: 1,221
You said the ApplicationDocs table is empty. So there are no applications that you can navigate to in the main form that will have anything at all to show in the subform.

You've got the subform set to not allow adding records and, I suspect, no headings. So when the main form navigates to a record that has no matching record in the subform you end up with a blank space because the subform literally has nothing to do.

Put some matching data into the subform's dataset and you'll see a good result.

Jim
Apr 6 '16 #5

P: 4
The subform will always be empty, because the main form is a Data Entry form.

I finally figured it out... Even though both the main form and subform are set to Data Entry = Yes, I still had to set the Allow Edits to Yes on the main form. My main form is in Single Form vies, it does not contain record selectors, and it suppresses the mouse scroll from cycling records, anyway. So, the user is still prevented from editing other records, even though I've now set Allow Edits... which is exactly what I want.

Thanks so much for your time and effort!
Apr 6 '16 #6

Post your reply

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