David-
1. If you save and close the form created by the Wizard, you should see TWO forms saved. One is the outer form, and the other is the subform. You can edit them independently. If you reopen the outer form in Design view, you should be able to see and also edit the subform inside its control.
2. Almost always put a subform in the Detail section of the outer form.
3. Yes, but why would you want to do that? The subform should get filtered when you fill in a value in the unbound control.
4. No, just be consistent.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Dec 11, 2016, at 2:42 PM, david.pratt@outlook.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
1. When I have a Parent-Child relationship for two tables, if I select the Parent table and use the Form control in the Access ribbon, Access will create a Form with Subform for me. That is a nice feature. However, I can seem to find no way to modify the Subform. I end up deleting it and manually creating and adding a subform in order to change some controls to combo boxes. Is there some way to modify the auto-created subform so that I do not have to go through these steps?
2. When I manually create add a subform, is it best to put the subform in the details section of the main form, or in the footer of the main form? Whenever I have tried to use the Footer section, I seem to be unable to control the "real estate"; there is a lot of white space in the detail section that I cannot seem to remove.
3. Is it possible to create a subform that is related to an unbound field in the main form? I tried to do that with no success, and ended up adding a new field and bound control to the main form to relate the subform to.
4. I see people using "sfrm" as the prefix and others using "fsub" as the prefix. Is there some advantage to one over the other, or is it just a matter of personal preference?
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar