473,748 Members | 2,471 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Open form3 using form1 connected via form2

2 New Member
I am new to access, so I will greatly appreciate any help....
I have three forms and three tables
Forms Names are:-
1) frmCommand
2) frmProductRevis ion
3) frmProduct

Field name for each Tables are:-
1) tblCommand
Field Name: C_UniqueID ----- C_Name ----- PR_UniqueID

2) tblProductRevis ion
Field Name: PR_UniqueID ----- P_UniqueID ----- PR_RevisionName

3) tblProduct:
Field Name: P_UniqueID ----- P_Name

There are two buttons in frmCommand:-
1) Open Product Revision
2) Open Product

There is one button in frmProductRevis ion:-
1) Open Product

In order to open frmProduct from frmCommand using a button, following two path can be used ?
a) frmCommand -> frmProductRevis ion -> frmProduct
--> Here, frmCommand has Button "Open Product Revision" which opens frmProductRevis ion filtered to that command, and frmProductRevis ion has button "Open Product" which open frmProduct filtered to that Revision.....

b) frmCommand -> frmProduct
--> HERS IS THE PROBLEM..... I want to open frmProduct by clicking on button "Open Product" on frmCommand directly, which will first filter Revision for that command and then filter Product for that Revision....
Instead of using path a) which opens frmProductRevis ion inorder to open frmProduct, I want to do all the filtering in frmCommand without opening frmProductRevis ion.... so that "Open Product" button on frmCommand can directly open frmProduct filtered for that particular command.....

Is there is way to open "frmProduct " from "frmCommand " by clicking Open Product button on "frmCommand " directly ???

Thank you
Attached Files
File Type: zip db2.zip (52.4 KB, 85 views)
Dec 1 '09 #1
3 2018
ChipR
1,287 Recognized Expert Top Contributor
Good summary of your tables and forms to start out with. Could you post the code involved in opening and filtering the other forms for those of us who can not download? The [code ] [/code ] tags will make it easy to read.
Dec 1 '09 #2
User1235
2 New Member
Here is the Code to open frmProductRevis ion from frmCommand

Expand|Select|Wrap|Line Numbers
  1.     stDocName = "frmProductRevision"
  2.  
  3.     stLinkCriteria = "[PR_UniqueID]=" & "'" & Me![PR_UniqueID] & "'"
  4.     DoCmd.OpenForm stDocName, , , stLinkCriteria

Here is the Code to open frmProduct from frmProductRevis ion

Expand|Select|Wrap|Line Numbers
  1.     stDocName = "frmProduct"
  2.  
  3.     stLinkCriteria = "[P_UniqueID]=" & "'" & Me![P_UniqueID] & "'"
  4.     DoCmd.OpenForm stDocName, , , stLinkCriteria


My Question is how can Open frmProduct directly from frmCommand ???
Dec 1 '09 #3
ChipR
1,287 Recognized Expert Top Contributor
What do you expect to see when you open frmProduct from frmCommand? It seems that when you open frmProduct from frmProductRevis ion, you filter it to one specific product. If you were to do this from frmCommand, you would have to filter on something else, and I can't tell what you want to filter on.
Dec 1 '09 #4

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

Similar topics

9
4932
by: Shyguy | last post by:
I have two forms that both open the same (3rd) form. The third form does the same thing, but a little differently depending on which form it is opened from. Is there a way I can check which form is open so I can flag how the third form acts? Thanks for any help
5
8198
by: aaaa | last post by:
I there, I have the folowing problem: In Form1 i have a button that open a new form (Form2). If a clik several times in that button, i open several form's of Form2. I don't want this!!! if a form2 is open it can not create a open a new form. How can a do this?? PS: the showdialog() method can not be used.
6
1618
by: pamelafluente | last post by:
Hi guys I am puzzed (???) with a probably stupid problem (VB2003). I must be doing something dumb ... I want to open a owned form (must *not* be mdi child) over an Mdi Container, when the Mdi container starts. I have a small demo program made of: Form1, Form2 (empty) and a "StartProgram" class which contain the following code. The startup object is set to be: Sub Main
3
5944
by: Karan | last post by:
I am calling finalize when form2 loads and deactivates form1 which closes form1. However, same thing is not happening in form2 because finalize is already called. Does anybody has solution to it. This code works well for splash screen. I searched alot on net for codes but they don't work. for example- (1) Public Sub CloseForm(formType As System.Type) For Each oForm as System.Windows.Forms.Form in me.MdiParent.MdiChildren If...
5
45945
by: Sudha Pune | last post by:
Hi all Just i want to close the form1 when i click the button1 on form1 and the same time i want to load the form2 on the same event. And i dont want to hide the form1 instead of close. Please post some piece of coding For the above i am using c# windows forms
1
5836
by: VMI | last post by:
I have a Windows Form Form1 (not MDI) and when I double-click on the Form, another Form2 will "pop up". How can I pass the text that I typed in Form2 to a textbox in Form1? I was thinking if it was possible that from Form2 I can call a public method in Form1 that updates the Textbox. I wanted to use something similar to the following code: Form childForm = this.MdiParent.MdiChildren ; Form f=null; f=(Form)childForm; frm_interactive...
4
5661
by: sajit | last post by:
hi folks, I am curently working in vb.net 2005. I am stuck at one technical glitch. How to open another form and close the parent foem in vb.net. I have tried every thing like me.close as well as i have tried using dispose method also. any help is appreciated. Thank You.
0
4585
Shashi Sadasivan
by: Shashi Sadasivan | last post by:
Hi All, i Have an application functionaluty which has 4 forms which are needed to interact by the user by dragging data from these forms to one another the main form is located in the MDI Parent and the rest are on their respective screen (3 other secondry screens) At the moment i am testing using 2 screens but i get a very similar behavious when i run it on a 4 screened system. For the 2 screen system: form1 opens in primary screen (ie...
10
2025
by: Sharma Neha | last post by:
i hav 3 forms.After clicking a button on form1 it shows form2 n similarly after clicking form2 ,form3 appears.i want to hav the value in a textbox in form3 from a textbox in form1.
0
8984
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
9530
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...
0
9363
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9312
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
8237
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...
1
6793
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
3300
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2775
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2206
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.