Topics Search

Hiding fields in a subform

Hiding fields in a subform
Views: 34
I have a form with a category field on it. The value for the category is selected from a list. Depending upon which value is selected for the category I want to hide or make visible various fields on a subform. So for example: only if the category is "Service" do I want the "Qty" field to be visible on the subform. How
Sponsored Links:

Similar posts...


Hiding Record in Report based on checkbox value - Access 2003

Hiding Record in Report based on checkbox value - Access 2003 Icon
I'm new enough at Access 2003 but I have been tasked at work with making a licensing database. I have a main form, and on that form is a subform called "Remarks". I have a report to print off a licence for that particular person. What I want to be able to do is check a checkbox in my "remarks" subform that will hide that record on the report. I've tried hiding the individual fields off the record on the report using the visible tag but it's not ideal as it still leaves an empty white space where everything is hidden

Subform not displaying

Subform not displaying Icon
I have a form (CourseTaken) that has a subform (UnitTotal). Everything is working except that the subform "detail fields" will not display until three fields have an entry though they do save the information.

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?

Subform Issue

Subform Issue Icon
To put it very simply, I have created a form with a subform. The only reason I am using a subform is because I have too many fields and I need a "scroll box" within a set of tabs. I have found no other way to do it.

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.

Prevent data field movement in subform

Prevent data field movement in subform Icon
I would like to prevent movement of the category, axis, data and filter fields of a Pivot Chart in a subform. I do not want the user to tinker and begin moving data fields (e.g. SumofTotal).

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?

Subforms 101

Subforms 101 Icon
I have just started using my first subform and I cannot seem to apply everything I have learnt up to this time when using the subform and main form

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

Many-to-many relationships & webforms

Many-to-many relationships & webforms Icon
Two of the tables will need to have a many-to-many relationship, and so will need a junction table that will contain just 3 fields (ID and the Primary key of each of the other tables).

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.

Entries not saved in fields

Entries not saved in fields Icon
I have a subform with two unbound fields. One calculates expiry date and the other counts down the days to expiry. When I input into the form and subform, the fields work as they should but if I save, close out and come back in, the form fields are blank. How do I ensure the data remains visible in the fields

hiding a part of the listbox

hiding a part of the listbox Icon
here's what I want to do, I have a list box with data in it, what I want to do is, when I click on new, another set of fields would appear and like hide the other half of the list box till the new data is entered and show the other half again.

I think this is doable through subform but can this be done with grouping too?

Editing Subform Data

Editing Subform Data Icon
I am trying to edit the fields in a subform, but it is not working. I checked all the property settings, and found out that the fields I want to edit were locked. I unlocked them, and verified the other properties. I still can't edit the subform values. I can edit the values in the table, and the problems there. I just can't do it in the subform! If I edit the values in the source query, I can view the changes in the subform, but can't actually make the changes from the subform

How to reach through subform to underlying table?

How to reach through subform to underlying table? Icon
With VBA I've learned to pull data from fields on my subform like this: sbfVendorDetail.Form.[Start Date]. However, fields such as the ID may not be on the subform since the user doesn't need to see it and it would take up space. Is there a way to read the ID field of the current record of the subform without putting the field on the form?