473,789 Members | 2,729 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Hiding fields in subform on report

RobH
56 New Member
I have a frm_PrintQuote that launches rpt_Quotation
rpt_Quotation includes a subform frm_QuoteParts
frm_QuoteParts has a field SubPrice

On the frm_PrintQuote I have a check box that indicates the .Visible for SubPrice fields - I have in the OnOpen for the frm_QuoteParts a SubPrice.visibl e = [Forms]![frm_PrintQuote]![CheckBox]

This works when I open just the frm_QuoteParts but it does not work when I open frm_Quotation
Sep 22 '07 #1
2 1421
FishVal
2,653 Recognized Expert Specialist
I have a frm_PrintQuote that launches rpt_Quotation
rpt_Quotation includes a subform frm_QuoteParts
frm_QuoteParts has a field SubPrice

On the frm_PrintQuote I have a check box that indicates the .Visible for SubPrice fields - I have in the OnOpen for the frm_QuoteParts a SubPrice.visibl e = [Forms]![frm_PrintQuote]![CheckBox]

This works when I open just the frm_QuoteParts but it does not work when I open frm_Quotation
Hi, RobH.

You cannot refer to subform via Forms collection.
Try the following
Expand|Select|Wrap|Line Numbers
  1. [Reports]![rpt_Quotation]![frm_PrintQuote]![CheckBox]
  2.  
Sep 22 '07 #2
NeoPa
32,579 Recognized Expert Moderator MVP
See Referring to Items on a Sub-Form for more ways to reference a subform / subreport.
Sep 22 '07 #3

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

Similar topics

7
5283
by: Caroline Bradford | last post by:
Hi there, I wonder if there is a kind and knowledgeable person out there who can help me with a sticky problem. I have a form with a subform which shows detailed data. For complicated reasons, which I won't go into, the detail which I require cannot be determined programmatically, so I planned to have two subforms, identical in design but with slightly different data, dependent on a criterion in the main form. Both will sit on the...
5
2446
by: Mary Litten | last post by:
Hi - (This is my very first post) I have gotten to this point of registering to post because I have been spinning my wheels so long, I believe I am all caught up in the weeds. (and mud) I have a form, that has several tabs. On one tab, I have a subform (wr_completion_subform). This subform is bound to a table (wr_completion_table). On the subform, I have a button from which I have added code to email a report of the completion data...
3
1880
by: David W. Fenton | last post by:
I ran into a weird problem with a subreport with an OnFormat event of the subreport detail. When I view the field list in report design view, all the aliased fields in the recordsource are available. But when the report runs, the aliased fields are inaccessible. Of course, this is causing a problem with the report running, and I can't figure it out. I've decompiled, I've compacted, I've recreated the recordsource. I've tried moving the...
13
8299
by: paquer | last post by:
Ok' I have 2 tables. The first being my main table where each record has a 'FigureID' txt box. (Indexed - No duplicates) The second being my sub table where reporting is entered for these Figures. Sometimes more than one at a time. I have 4 'FigureID' txt boxes on this subtable.(All Indexed - Duplicates OK) When I set the Master/Child link for the first FigureID on the Subtable I have no problems.
4
5887
by: Henrootje | last post by:
I have a REPORT with in it a subFORM Now I have this label (lblMonth) that I want to change. How should I do this? What would be the proper event to do this? The lblMonth should contain the name of the month as jan 07 Any ideas?
11
1758
by: BASSPU03 | last post by:
Tomorrow's my final presentation of my DB and I ran into an unexpected problem: I access a main form called frmViewAllResources with several tabbed subforms through my switchboard. There's a preview and print button on the main form that generates a report called "Commodities." It previews and prints all the relevant fields from the main form and subform just fine. On my switchboard, I can also access a form to print reports using a date...
6
1786
by: 3338761 | last post by:
I'm a beginner programmer so bear with me if this seems very simple... I have a subform which I don't want to have displayed until the user has entered first name, last name, extension, and chose a dept. from a combobox. The If condition I tried for the first name was: If Me.Employee_First_Name.Value = Null Then Me.Report_Sub.Visible = False Else Me.Report_Sub.Visible = True
4
1975
by: PotatoChip | last post by:
I have a form which tracks Change Requests. Sometimes documentation needs to be updated as a result of the change. So, instead of bogging down the form with mulitple comment fields, I have created a subform to input any affected documents. Is there a way to hide the subform (as the form is already quite messy and large) if no documents are affected? I was thinking if the user ticks a checkbox indicating documents are affected, the subform would...
12
3542
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to print the report three times, but do not know how
0
9666
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9511
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10408
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10139
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9983
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9020
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6769
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
3700
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2909
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.