473,327 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Open form3 using form1 connected via form2

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) frmProductRevision
3) frmProduct

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

2) tblProductRevision
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 frmProductRevision:-
1) Open Product

In order to open frmProduct from frmCommand using a button, following two path can be used ?
a) frmCommand -> frmProductRevision -> frmProduct
--> Here, frmCommand has Button "Open Product Revision" which opens frmProductRevision filtered to that command, and frmProductRevision 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 frmProductRevision inorder to open frmProduct, I want to do all the filtering in frmCommand without opening frmProductRevision.... 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, 84 views)
Dec 1 '09 #1
3 2000
ChipR
1,287 Expert 1GB
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
Here is the Code to open frmProductRevision 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 frmProductRevision

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 Expert 1GB
What do you expect to see when you open frmProduct from frmCommand? It seems that when you open frmProduct from frmProductRevision, 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
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...
5
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...
6
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...
3
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....
5
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....
1
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...
4
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...
0
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...
10
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.