Recent content by Alex Motilal

  1. A

    Another form's button to activate.

    Can you elaborate please. The second form's Close Button Event: Private Sub Command10_Click() On Error GoTo Command10_Click_Err DoCmd.Close , "" Command10_Click_Exit: Exit Sub Command10_Click_Err: MsgBox Error$ Resume Command10_Click_Exit End Sub
  2. A

    Another form's button to activate.

    Hi all. I have a form and on clicking a button another form will pop up to enter data. On clicking the Close button of the Pop Up form, the Update Button of the original form should activate (that is should act as if the button clicked). Is it possible? If so please help me with the code. Thanks.
  3. A

    Solved Update form & remain in the same record

    Thanks a lot. I replaces with Me.Dirty=False & it works fine. Thanks again for your quick solution.
  4. A

    Solved Update form & remain in the same record

    Thank you. Following is the code at present: Private Sub cmdSave_Click() On Error GoTo cmdSave_Click_Err On Error Resume Next DoCmd.RunCommand acCmdSaveRecord If (MacroError <> 0) Then Beep MsgBox MacroError.Description, vbOKOnly, "" End If...
  5. A

    Solved Update form & remain in the same record

    Hi everyone, I have a form (Single Form) for entering data which has multiple fields. After entering the data, when I click the Update Button, it takes to the first record. I do want the form to remain in the same record. I need the correct code. Please some one help. Thanks
  6. A

    Controls in Main Form & Subform

    Hi, I succeeded by placing the following code. Private Sub PersonID_DblClick(Cancel As Integer) Dim strCriteria As String strCriteria = "PersonID = " & Me.PersonID Me.Parent.Form.Filter = strCriteria Me.Parent.Form.FilterOn = True End Sub The problem is by clearing the filter...
  7. A

    Solved Code for a button in the main form

    Sorry, I put the name of the subform, instead of the name which I gave in the main form. It is working fine. Thanks a lot.
  8. A

    Solved Code for a button in the main form

    Thank you. However, it is showing Run time error 2465.
  9. A

    Solved Code for a button in the main form

    Hello experts, I do have a Main form with a continuous SubForm. When the button on the main form is clicked, another form should open based on the record selected in the SubForm. I need the code for that. Thanks Alex
  10. A

    Controls in Main Form & Subform

    I am glad to inform that I succeeded in the Double Click event of both the Combo Boxes in the Main Form: Code: Private Sub cmbFather_DblClick(Cancel As Integer) Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[PersonID] = " & Str(Nz(Me![cmbFather], 0)) If Not rs.EOF...
  11. A

    Controls in Main Form & Subform

    This is the screen shot of the Main Form. What I want is when the Mother (Or Father) Combo Box is Double Clicked, the PersonID should change to that of the PersonID of the Combo Box and display the related data. Since all data come from tblPersons, to link the Subform PersonID to that of the...
  12. A

    Controls in Main Form & Subform

    Mine is different. What I need is when the Combo Box on the Main Form is double clicked, the data should change in the main form, Also when the PersonID in the subform is double clicked, the main form data should change.
  13. A

    Controls in Main Form & Subform

    The SQL of the Query on which the Subform is based: SELECT tbl_Person.* FROM tbl_Person WHERE (((tbl_Person.MotherID)=[Forms]![Frm_Persons]![PersonID])) OR (((tbl_Person.FatherID)=[Forms]![Frm_Persons]![PersonID]));
  14. A

    Controls in Main Form & Subform

    Thank you, tblPersons is the record source of the Main Form. In fact the entire Persons are in that table. I linked the Subform to the Main form through a Query.
  15. A

    Controls in Main Form & Subform

    This is my first post in this Forum. I am creating a Family Tree Database. tblPersons contains the fields, PersonID, FirstName, MiddleName, LastName , Gender & relevant Dates & data. Persons are added in the Main Form which contains a Subform where Children are added related to the PersonID on...
Top Bottom