Hiding fields in a subform
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The other problem is that the unittotal "footer field" will not display the total until all three fields contain a value.
all three fields are based on different queries (which is why the subform) with the control source as an overriding query UnitTotalAll which contains the three subqueries.
I tried putting the fields on the main form and using DLookup but could never get it to work.
How can I get the subform to display all the time? and the total to display when any one of the three has a value?
I figure it is the same problem however I am stuck on a number of things such as passing values to other forms, getting combo boxes to work, assigning values and code to the subform, hiding and showing the subform, etc
Previously I have been using code such as
Forms!frmSubForm1.Field1.Visible=True (to other forms or using value from other forms)
however these don't work when using a subform as it cannot find the form any quick advice as I think this may solve many of my subform problems.
I tried making the code public (removing private) but this didn't work
I think this is doable through subform but can this be done with grouping too?
This method works great except for one scenario: adding records.
I have about 15 fields that I need to display, so the 15 fields are on a subform. The form and subform both reference the same table. The form is linked to the subform on its AutoNumber.
the subform doesn't seem to be linking to the newly created record and I am getting errors when adding values.
The form I am concerned with is called "SAMPLE RECORD." You will see that if you open it, it works like I want it to, but if you click the + to add a newrecord, if you start typing data in the subform I quickly get errors when exiting.
The idea is for the user to view the displayed bar charts in this subform.
While the subform is based on a query, I do not see any property in design view that would stop a user from manipulating these fields.
What subform properties should I be using?
I still can't edit the subform values. I can edit the values in the table, and the query.no problems there. I just can't do it in the subform! If I edit thevalues in the source query, I can view the changes in the subform, but can't actually make the changes from the subform.
I have no idea how to structure data entry forms for these tables, as I need to have Table 1 as the main table, with the other table included as a subform on which data can be added in many fields.
I've read that a subform within this type of relationship should be based on the junction table, but how do I then include the fields of the table it links with (the 3rd table) within the subform? There's little use for a subform that just contains ID fields.
The subform needs to accommodate a combo box, as well as yes/no & text fields, and the user will also need to be able to edit, add & remove data in the subform over time and it must retain links to the main form.
I think hiding them is most efficient.
I've explored several variations of the below code with no effect what so ever. I've tried calling on the subform more specifically. (I.e. [Forms]![Main Form]![Subform]![Control Name].Visible = False)
Also, Should it work in this general format or do I need to specifically "call" on the Sub? For example, OnOpen, etc.