Hidden Forms and Subforms

I'm in the process of editing and expanding an existing database. Basically all I need to do is to copy what is already there and change the record source. I can open the form that I need to copy however this form does not appear in the forms list (neither does the subreport on the form). Any ideas how to find this form and subform?

I've attached a copy of the database, if you open the form "Club Secretaries Contacts" then click on one of the buttons at the bottom i.e. "Summer Sunday" this will open the form I can not find. The subform I can not find is on this form

Sponsored Links:

Related Topics

Editing in a subform within a report
I've definitely been trying to do some stuff that Access wasn't exactly engineered to do, but I'm pretty sure Access was meant to have subforms in reports. Yet for some reason, I can't edit the data in any of my subforms within a certain report.

It's complex, but the subforms are enabled, the forms within them are unbound (no outer-join issues) and enabled. The subforms are hidden and made visible based on user events in a subreport.

The funny thing is, I could swear I used these forms before. And now I can't type in them.

I'm at a complete loss and frustrated with the lack of specifics about using subforms in reports on the internet. Anybody have


Editing in a subform within a report
I've definitely been trying to do some stuff that Access wasn't exactly engineered to do, but I'm pretty sure Access was meant to have subforms in reports. Yet for some reason, Ican't edit the data in any of my subforms within a certain report.

It's complex, but the subforms are enabled, the forms within them are unbound (no outer-join issues) and enabled. The subforms are hidden and made visible based on user events in a subreport.

The funny thing is, I could swear I used these forms before. And now I can't type in them.

I'm at a complete loss and frustrated with the lack of specifics about using subforms in reports on the internet.


Connect two subforms
I have a forms with 2 subforms, one for the business, one for the employee. The subforms are into a third form. I need to link the 2 subforms. How


subforms in unbound forms
I have unbound forms name: Project_List, in it there is two subforms bound in a query. Is there a way to link the two subforms, so that when I click a record on the first subforms. it filters a related records.

Let's say in field name: Doc_Name when I click a record from this field, access will filter related date in the 2nd subforms.


Use subforms
Use subforms to work with more than one form at a time. Learn how to create and customize subforms inside main forms in Microsoft Office Access 2003. After completing this course you will be able to:
1) Explain how subforms work.
2) Create subforms using the Form Wizard and the SubForm Wizard.
3) Change the layout of subforms.
4) Use subforms to perform calculations and display the results in the main form.


subforms update ALL records at once
I have a set of tables that are accessed by forms and subforms. A couple of the subforms seem to update ALL of the records in the relevant table when data is entered, while other subforms correctly update only the viewed record
Ideas on where to start debugging this would be greatly appreciated!


Access on MAC
Today I was going to test an Access database in a Mac computer, and I realize there is no Access on Mac!

any solutions? The database is quite complex, with forms with hidden reference to other forms, subforms,etc.

I know that keeping the data is not a problem, but anyway os launching Access on a Mac


Subforms constantly refresh
I am having trouble with subforms constantly refreshing. I am building a form with a timesheet (first subform) and a sortable project list (second subform); each of the subforms is a continuous by default. However when both of these forms are on the form they start constantly refreshing. I commented out all the code on both subforms and the main form but it still does this. There are no macros either.

Does anyone know how I could fix this? As I said this doesn't seem to happen when only one of the subforms exists on the form, but I really need both to make this at all user friendly.

Edit: Forgot to specify this is in Access


Subforms constantly refresh
I am having trouble with subforms constantly refreshing. I am building a form with a timesheet (first subform) and a sortable project list (second subform); each of the subforms is a continuous by default.

However when both of these forms are on the form they start constantly refreshing. I commented out the code on both subforms and the main form but it still does this. There are no macros either.

As I said this doesn't seem to happen when only one of the subforms exists on the form, but I really need both to make this at all user friendly.

Edit: Forgot to specify this is in Access 2007.


Access 2007, all subforms read-only
I've converted an application from Access 2003 to Access 2007. Everything was looking good until I tried editing some data from a subform and discovered that all forms, when displayed as a subform, are read-only.

I tried the old version and all of the subforms work fine and I even converted the old version again and all of the subforms are working -- but I've done a lot of work on first conversion so would like to not need to start over, if possible.

This is not an issue with joins or read-only queries because some of the forms being used as a subform that are read-only are linked directly to a table. Also if a form is placed as a subform on another form, but is not linked to the master form at all, editing works. I checked the obvious (allow edits, enabled, locked, etc.)

Is there a new option in 2007 that affects subforms -- like is there an option somewhere that sets all subforms to read-only? Forms/subforms that were working no longer do so


saving data on a form to another form (or table?)
- I am developing this database, I have created all the tables and the forms. I created the forms with subforms - the original sheet has several different selections per section - so I used subforms for each section. What I'd like to do now is save all the information entered into the form (and subforms) either to another form or to a table so the data can be viewed on screen or printed.


Datasheet Scrollbars
I'm getting inconsistent results when I change the scrollbar property on my forms using Datasheet View. On some I can't get a horizontal scrollbar to save my life, but I have at least one that does show a horizontal scrollbar, so I know it can be done. All of these datasheet forms are embeded in subforms. It is very awkward to not have this. The user must click on a visible field and tab over to the the hidden one.

Please ask if you need more info. I can't upload the database, but I'll be happy to provide more information


Creating subforms
Microsoft Access Tutorial: To learn the creation of forms with subforms included.


Set subform AllowEdits property from another form
When my form that contains two subforms is opened from certain other forms, I want to disallow edits on one of the subforms and on the parent.

Docmd.openForm "ParentName"
Forms!ParentName.AllowEdits=False
This only works for the parent-the subforms still allow edits (something that affects totals on the Parent)

I added:
Forms!ParentName.Form.Child2Name.AllowEdits=False

which gives me an error message.

I am using A2007 with W7.


Subforms : Create form within form
The advantages of forms within forms, Creating the main form, Creating the subform, Linking the main form and subform, Linking forms and subforms
manually, Non-synchronized forms, Aesthetic refinements. (pdf file, install Acrobat Reader to read this tutorial).


Set subform AllowEdits property from another form
When my form that contains two subforms is opened from certain other forms, I want to disallow edits on one of the subforms and on the parent.
My code:

Docmd.openForm "ParentName"
Forms!ParentName.AllowEdits=False
This only works for the parent-the subforms still allow edits (something that affects totals on the Parent)

I added:
Forms!ParentName.Form.Child2Name.AllowEdits=False

which gives me an error message.

I am using A2007 with W7.

I know that I can open the whole form as read-only, but would like child1 to be available for editing. I have searched, and found things that I thought would apply, but am missing something.


Designing forms - what is important?
I'm working on creating a database, and I've already set up the tables and relations. Right now, I'm stuck on the forms. My idea of forms is just forms with subforms, so you can update allthe related data in the same form.

But now that I'm designing the forms, I find that my forms are very cramped, or that I have a lot of subforms. what is important when designing forms? how do you knowwhen to put a subform and when not to put a subform? If you say related data, but the whole database itself is related isn't it?


Subform/tabbed form tutorial
I'm still lurking and trying to do bits on my db when I can. Weather is getting a bit rubbish now so will probably be doing more on the PC.

Would someone be kind enough to point me in the direction of a good tut on subforms and tabbed forms?

I want multiple tabbed forms, I'm guessing I have to put them in as subforms? Before I start doing that can anyone tell me if there any drawbacks/limitations to using them this way?


Refresh/Requery Subforms
Could anyone please help with the following.

I've got a datasheet view form and got a couple of Subforms in a separate Tab Control (Ofcourse on different tab pages).

All these three forms (The Datasheet view form and the two subforms) have a Customer ID in common.

I want to refresh/requery the subforms in the tab pages every time I select a row in the datasheet view form depending upon the customer ID.

NB: the subforms display the data retrieved from a query


Cascaded Form Filtering with Subforms
I need to use unbound controls in a form header to filter a form. There is a very well written insight that describes filtering forms with unbound controls in the form header. ([LINK]) However, it clearly states that the example is simple and does not include subforms.

My form has two subforms each with a single combo box control. I need to filter records in my form based on values in my subforms and I need them to cascade.