Open Previous Form From Current Form Sub Form
I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Open Form Command Button Fills In Text And Date Fields From Previous Form
I currently have two forms: frmE_SAFind and frmE_SAOrder frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate] Example: IDPO Date btnOpnFrm 6543 2/1/05 btnOpnFrm 5681 1/1/05 frmE_SAOrder shows order details including [txtIDPO] and [dtmDate] I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command? Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details. Hopefully I made myself clear enough to understand. Thanks for your help!
View Replies !
View Related
Open Query Result On Current Form?
After creating my query based on some combo boxes [Forms]![DailyWorkReport]![commonth] which are located on my form I do have a command button that will open the results in a report, how can I show the results on the current form? I have added an image to make things easier
View Replies !
View Related
Query Using Field From Current Open Form Using VBA Function
I am trying to resolve an issue of being able to use a query from many different forms where the query is dependent on the date selected in the current open form. Right now it calls the function getDate() which works fine. Unfortunatly the function is called before the form is fully loaded and the control I want to pass has no value/doesn't exist yet and I get a "Runtime error 13 Type-Mismatch" Here is the function code: Function getDate() As String If fIsLoaded("F_SupplierData") Then getDate = Form_F_SupplierData.txtDate Else getDate = "01/01/1901" End If End Function Function fIsLoaded(ByVal strFormName As String) As Integer 'Returns a 0 if form is not open or a -1 if Open If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <> 0 Then If Forms(strFormName).CurrentView <> 0 Then fIsLoaded = True End If End If End Function Is there a way to detect the state of the text field itself (if it is open, closed, dirty)? Or if anyone has a better way to tie a query to multiple forms?
View Replies !
View Related
Email Current Contact On Form/Open Outlook
I've researched all the email topics, but can't find what I am trying to do. Most of these topics are talking about emailing a record or form or something. I have a form that contains thousands of contacts address, telephone, email, etc. I would like to create a button that on click would open Outlook and grab ONLY the email of the current contact I am looking at on the form at that time and add that email address to the [To:] box of a new email. Thanks you guys, I'm learning...slowly, but it's coming.
View Replies !
View Related
Event From One Form That Opens Another Form: How Do I Open To The Right Record?
I have code for a button click event. Essentially I have a main table form that I use to enter customer data and info. I also have a button that I use to add that customer to a separate table that I use for special Customers. My code copies all the data I need copied to my other table, so I wont waste space here typing my code that actually copies the data to the new table. What I will list are the two commands I am using after that code, to close the current form (the one with the button) and open the form for entering special customer information (the form to edit data on my other table). It works flawlessly, but when it opens the other form, it opens to the first record. I want to know how to make it open to the record which I was viewing when I clicked the button to copy the data. DoCmd.OpenForm "Special Customer Data Entry", , , Number = Me.Number DoCmd.Close acForm, "Customer Data"
View Replies !
View Related
Open Form Not Adding Record And Use An Add Button On Form
I have a database with three tables table 1 (form1) reference (PK) auto number table 2 (form2) Reference (fK) workbook reference (PK) auto number Table 3 (sub form within in form2) Reference (FK) workbook reference (fK) data Reference (pk) auto number Each table is a form that is linked via the keys. On form 1 i have a button that is to open the form2, which it does but every time i open the form a new record is added. Why and how do i prevent this. Then what i want to do is add a button for a new form on table 2 form but use the same reference as the record as presently displayed. How do i add new record using the same Reference but new workbook Reference? Thanks is advance
View Replies !
View Related
Need Code To Open TeacherDetailFrm Form Main Form.
Hi I need code to open TeacherDetailFrm form Main form. I have TeacherStudentSubFr*m on the Mainform, FirstNameTxt on the TeacherStudentSubFr*m, and TeacherDetailFrm. I need code to open the TeacherDetailFrm By double click on the FirstNameTxt. I use this code but no data come and query dialog box come. Private Sub FirstNameTxt_DblCli*ck(Cancel As Integer) Dim DocSubForm As String Dim DocText As String DocSubForm = "TeacherDetailFrm" 'DocText = "[Result]=" & "'" & Me![result] & "'" DoCmd.OpenForm DocSubForm, , , "[ FirstNameFld ]=forms![TeacherStudentSubFrm]![ FirstNameTxt]" End Sub I like to upload the file but no way in this forum
View Replies !
View Related
Reopen A Form In A Current Form
After I save the record, I would like to clear all the data in the form and allow use to add another new record. I use code like me.mycontrol.myfield=null, it sets all text box to null, but the selectedlist box still filled in. The only way is to close the form and reopen the form. I have some code in the open form event. This makes the form displayed correctly. But this is really not convenient, the user have to close the from and reopen the form in order to see everything refreshed again amd enter new record Is there any way that I can use a button in the current form that close the form and reopen the form, which actually lookes reset the page.? Thanks
View Replies !
View Related
Please Help..Unable To Open A Form In Form View
hi... I am not able to open a form either by double clicking on the form icon or by using openform command in macro. It is actaully opening but not visible. because if I tried renaming ithe form after double clicking. it says...u cant rename a form which is open...but i cnt c it.. it ws opening before... ut after adding some event procedures to its controls...its not opening.. i chked all of thm... wht can b the reason... plzz help me...its v urgent.. thnks in advance...
View Replies !
View Related
Please Help..Unable To Open A Form In Form View
hi... I am not able to open a form either by double clicking on the form icon or by using openform command in macro. It is actaully opening but not visible. because if I tried renaming ithe form after double clicking. it says...u cant rename a form which is open...but i cnt c it.. it ws opening before... ut after adding some event procedures to its controls...its not opening.. i chked all of thm... wht can b the reason... by the way the pop up property of form is set on... if I set this property off it opens but i wnt the form to popup.. plzz help me...its v urgent.. thnks in advance...
View Replies !
View Related
Open Form On Menu Then Close Old Form
I've a custom menu bar from which I can choose any of my forms. However when you choose a new form the old form stays open, sloppy in my mind. Is there any way i can choose the new form from the menu bar & close the previous form? I've tried to close on deactivate, w/ no luck.
View Replies !
View Related
Hide Form Name On Open Form
Is there any way to either hide or change the form name that shows at the top of an open form - instead of renaming the form and all associated queries, reports etc. Maybe a cosmetic shortcut (wishful thinking here - bear with me). Thanx in advance..
View Replies !
View Related
|
TRACKER
